sys_viewcolumns

CData ODBC Driver for Bugzilla 2019 - Build 19.0.7354

Describes the columns of the available views.

The following query returns the columns and data types for a specified view:

SELECT ColumnName, DataTypeName FROM sys_viewcolumns WHERE TableName='MyView'

Columns


Name	Type	Description
CatalogName	String	The name of the database containing the view.
SchemaName	String	The name of the schema containing the view.
TableName	String	The name of the view.
ColumnName	String	The name of the column.
DataTypeName	String	The name of the data type.
DataType	Int32	An integer indicating the data type of the column. This value is determined at run time based on the environment.
Length	Int32	The length in characters of the column or the numeric precision.
NumericPrecision	Int32	The maximum number of digits in numeric data. The column length in characters for character and date-time data.
NumericScale	Int32	The column scale or number of digits to the right of the decimal point.
IsNullable	Boolean	Whether the column can contain null.
Description	String	The column description.
Ordinal	Int32	The sequence number of the column.
IsAutoIncrement	String	Whether the column value is assigned in fixed increments.
IsGeneratedColumn	String	Whether the column is generated.
IsReadOnly	Boolean	Whether the column is read-only.
IsKey	Boolean	Whether the column is a primary key.
IsHidden	Boolean	Whether the column is hidden.