VistaDB 6
VistaDB / Developer's Guide / SQL Reference / Functions / Special Functions / GETVIEWCOLUMNS
In This Topic
GETVIEWCOLUMNS
In This Topic
# Column Name Column Data Type Description
0 VIEW_NAME NVarchar View name as assigned at creation time
1 COLUMN_NAME NVarchar Column name
2 BASE_COLUMN_NAME NVarchar Column name defined in select command
3 COLUMN_ORDINAL Int32 Column ordinal
4 DATA_TYPE Byte Data type of the column. To get VistaDBType object use casting: (VistaDBType)DATA_TYPE
5 DATA_TYPE_NAME NVarchar Data type name
6 IS_EXTENDED_TYPE Boolean True - is column has extended data type
7 COLUMN_SIZE Int32 Column size. Applicable only for character columns.
8 CODE_PAGE Int32 Code page. Applicable only for character columns.
9 ENCRYPTED Boolean True - if column is encrypted
10 COLUMN_CAPTION NVarchar Column caption
11 COLUMN_DESCRIPTION NVarchar Column description
12 IS_UNIQUE Boolean True - if column is unique
13 IS_KEY Boolean True - if column is primary key
14 ALLOW_NULL Boolean True - if column allow nulls
15 IDENTITY_VALUE NVarchar Current identity value for column (right now always null)
16 IDENTITY_STEP NVarchar Identity step. If this value is NULL - column doesn't have an identity value
17 IDENTITY_SEED NVarchar Identity seed
18 DEFAULT_VALUE NVarchar Column default value
19 USE_DEFVAL_IN_UPDATE Boolean True - if default value used in updates


See Also