TABLES
The TABLES system view lists the tables and views on which the current ident, or PUBLIC, holds one or more privileges (INSERT, DELETE or SELECT; or REFERENCES or UPDATE on one or more columns).
Column name
|
Data type
|
Description
|
| TABLE_CAT |
VARCHAR(128) |
The name of the catalog containing the table or view. |
| TABLE_SCHEM |
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. |
| REMARKS |
VARCHAR(254) |
May contain descriptive information about the table. |
