Lists the tables defined in the catalog.
This view is part of the ANSI SQL-2 standard Information Schema.
Column |
Data Type |
N |
Description |
RECORD_NUMBER |
integer |
n |
unique identifier for this record of metadata |
TABLE_CATALOG |
identifier |
n |
table catalog |
TABLE_SCHEMA |
identifier |
n |
table schema |
TABLE_NAME |
identifier |
n |
table name |
TABLE_TYPE |
enumeration |
n |
table type: Base Table or View |