Use SVV_ALL_TABLES to view a union of Amazon Redshift tables as shown in SVV_REDSHIFT_TABLES and the consolidated list of all external tables from all external schemas. For information about Amazon Redshift tables, see SVV_REDSHIFT_TABLES.
SVV_ALL_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 |
|---|---|---|
| database_name | varchar(128) | The name of the database where the table exists. |
| schema_name | varchar(128) | The schema name for the table. |
| table_name | varchar(128) | The name of the table. |
| table_acl | varchar(128) | The string that defines the permission for the specified user or user group for the table. |
| table_type | varchar(128) | The type of the table. Possible values are views, base tables, external tables, and shared tables. |
| remarks | varchar(256) | Remarks. |
Sample queries
The following example returns the output of SVV_ALL_TABLES.
SELECT *
FROM svv_all_tables
WHERE database_name = 'tickit_db'
ORDER BY TABLE_NAME,
SCHEMA_NAME
LIMIT 5;
database_name | schema_name | table_name | table_type | table_acl | remarks
---------------+-------------+--------------------------+------------+-----------+---------
tickit_db | public | tickit_category_redshift | TABLE | |
tickit_db | public | tickit_date_redshift | TABLE | |
tickit_db | public | tickit_event_redshift | TABLE | |
tickit_db | public | tickit_listing_redshift | TABLE | |
tickit_db | public | tickit_sales_redshift | TABLE | |If the table_acl value is null, no access privileges have been explicitly granted to the corresponding table.
