The ViewColumns schema returns information about Columns of VIEW objects. Metadata for this schema cannot be directly accessed using the Advanced SQL Engine Data Dictionary views. A table must be mapped to this schema. The mapped table will contain the metadata for the columns of the views. This mapping is defined by adding entries to the application configuration file. Refer to Configuration File Entity Section for more information.

Column Name	Data Type	Description
Id	String	Returns a unique Id for the table COLUMN. The format is Database Name.Table Name.Column Name
Name	String	Returns the name of the COLUMN.
Ordinal	Int32	Returns the position of the column in the TABLE.
IsNullable	Boolean	Returns a code to indicate whether or not the column may have a null value: true indicates it may have a null value. false indicates it may not have a null value.
ColumnType	TypeSpecification
ColumnType.TypeName	String	Returns the SQL Data Type name. TypeName will return the User Defined Type name if the column is a UDT.
ColumnType.MaxLength	Int32?	Returns the maximum length of the Column for the following Data Types: BYTE or VARBYTE CHAR or VARCHAR BLOB or CLOB Time With Time Zone All Interval Data Types All Period Types
ColumnType.Precision	Int32?	Returns information about the maximum number of digits (base 10) that can be stored in a Numeric data type: ByteInt, SmallInt, Integer and BigInt Decimal or Numeric Float or Double Precision
ColumnType.DateTimePrecision	Int32?	Returns information about the maximum numbers of fractional seconds to the right of the decimal point for the following data types: Timestamp and Timestamp With Time Zone Time and Time With Time Zone Interval Day To Second Interval Hour To Second Interval Minute To Second Interval Second
ColumnType.Scale	Int32?	Returns information about the maximum number of fractional digits (base 10) to the right of the decimal point for Decimal data type.
Collation	Collation	This field is always set to NULL.
CharacterSet	CharacterSet
CharacterSet.CatalogName	String	This field is always set to NULL.
CharacterSet.SchemaName	String	This field is always set to NULL.
CharacterSet.Name	String	Returns information about the column character data type: Unicode KanjiSJIS Graphic Kanji1 NULL
ColumnType.IsMultiSet	Boolean	This field is always set to False.
IsIdentity	Boolean	Returns: false indicating the column is not identity column. true indicating the column is an identity column.
IsStoreGenerated	Boolean	This field is always set to False.
Default	String	Returns any default value assigned to the column.