Menu
Amazon Redshift
Database Developer Guide (API Version 2012-12-01)

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 metadata to which they have access.

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. The following are possible values:
  • VIEW

  • EXTERNAL TABLE

  • BASE TABLE

remarks text Remarks

On this page: