CONNX Data Integration Suite 14.8.0 | Reference Guide | CONNX Catalog Structure | View Description Tables | Tables View
 
Tables View
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