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 |