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. |
