TABLES
The TABLES system view lists tables to which the current ident, or PUBLIC, has access.
Column name
|
Data type
|
Description
|
| TABLE_CATALOG |
VARCHAR(128) |
The name of the catalog containing the table or view. |
| TABLE_SCHEMA |
VARCHAR(128) |
The name of the schema containing the table or view. |
| TABLE_NAME |
VARCHAR(128) |
The name of the table or view. |
| TABLE_TYPE |
VARCHAR(20) |
One of:
"BASE TABLE" = the row describes a table
"VIEW" = the row describes a view. |
