SVV_TABLES - Amazon Redshift

SVV_TABLES

Use SVV_TABLES to view tables in local and external catalogs.

SVV_TABLES 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
table_catalog text The name of the catalog where the table exists.
table_schema text The name the schema for the table.
table_name text The name of the table.
table_type text The type of table. Possible values are views, external tables, and base tables.
remarks text Remarks.