SVV_REDSHIFT_SCHEMAS - Amazon Redshift
Table columnsSample query
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

SVV_REDSHIFT_SCHEMAS

Use SVV_REDSHIFT_SCHEMAS to view a list of all schemas that a user has access to. This set of schemas includes the schemas on the cluster and the schemas from datashares provided by remote clusters.

SVV_REDSHIFT_SCHEMAS is visible to all users. Superusers can see all rows; regular users can see only their own data. For more information, see Visibility of data in system tables and views.

Table columns

Column name Data type Description
database_name varchar(128) The name of the database where a specified schema exists.
schema_name varchar(128) The namespace or schema name.
schema_owner integer The internal user ID of the schema owner.
schema_type varchar(16) The type of the schema. Possible values are shared and local schemas.
schema_acl varchar(128) The string that defines the permissions for the specified user or user group for the schema.
schema_option varchar(128) The options of the schema.

Sample query

The following example returns the output of SVV_REDSHIFT_SCHEMAS.

SELECT *
FROM svv_redshift_schemas
WHERE database_name = 'tickit_db'
ORDER BY database_name,
    SCHEMA_NAME;

database_name |    schema_name     | schema_owner | schema_type | schema_acl | schema_option
--------------+--------------------+--------------+-------------+------------+---------------
   tickit_db  |       public       |       1      |    shared   |            |