CLASSES view¶
This Information Schema view displays a row for each class in the database.
- See also:
Columns¶
Column Name | Data Type | Description |
|---|---|---|
NAME | VARCHAR | Name of the instance. |
SCHEMA_NAME | VARCHAR | Name of the schema the instance belongs to. |
DATABASE_NAME | VARCHAR | Name of the database the instance belongs to. |
VERSION | VARCHAR | Version of the class that is currently active in this account. |
OWNER | VARCHAR | Name of the role that owns the instance. |
OWNER_ROLE_TYPE | VARCHAR | The internal/system-generated identifier of the role that owns the instance of the class. |
IS_SERVICE_CLASS | VARCHAR | TRUE if the class is a SERVICE class. |
CREATED | TIMESTAMP_LTZ | Date and time when the instance was created. |
COMMENT | VARCHAR | Comment for the instance. |
Usage notes¶
The view only displays objects for which the current role for the session has been granted access privileges.
Examples¶
Retrieve all classes in the SNOWFLAKE database:
SELECT name, schema_name, database_name, version FROM SNOWFLAKE.INFORMATION_SCHEMA.CLASSES;