CONNX Data Integration Suite 14.8.0 | Reference Guide | CONNX Catalog Structure | View Description Tables | Views View
 
Views View
Lists the views 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
VIEW_DEFINITION
char(4000)
n
The SQL source string of the view definition.
CHECK_OPTION
enumeration
n
Cascade
IS_UPDATABLE
yes_no
n
is this field updatable?
SCHEMA_CONTEXT
identifier
n
dbo