ODBC_COLUMNS
Provides table column information. The format is defined by the ODBC standard for the ODBC SQLColumns metadata. Details on the ODBC SQLColumns format are available in the ODBC specification: http://msdn.microsoft.com/en-us/library/windows/desktop/ms711683%28v=vs.85%29.aspx.
Column Name | Data Type | Description |
---|---|---|
SCHEMA_NAME
|
VARCHAR |
The name of the schema in which the column resides. If the column does not reside in a schema, this field is empty. |
TABLE_NAME
|
VARCHAR |
The name of the table in which the column resides. |
COLUMN_NAME
|
VARCHAR |
The name of the column. |
DATA_TYPE
|
INTEGER |
The data type of the column. This can be an ODBC SQL data type or a driver-specific SQL data type. This column corresponds to the ODBC_TYPE column in the TYPES table. |
DATA_TYPE_NAME
|
VARCHAR |
The driver-specific data type name. |
COLUMN_SIZE
|
INTEGER |
The ODBC-defined data size of the column. |
BUFFER_LENGTH
|
INTEGER |
The transfer octet length of a column is the maximum number of bytes returned to the application when data is transferred to its default C data type. See http://msdn.microsoft.com/en-us/library/windows/desktop/ms713979%28v=vs.85%29.aspx |
DECIMAL_DIGITS
|
INTEGER |
The total number of significant digits to the right of the decimal point. This value has no meaning for non-decimal data types. |
NUM_PREC_RADIX
|
INTEGER |
The radix Vertica reports decimal_digits and columns_size as. This value is always 10, because it refers to a number of decimal digits, rather than a number of bits. |
NULLABLE
|
BOOLEAN |
Indicates whether the column can contain null values. Values are 0 or 1. |
REMARKS
|
VARCHAR |
The textual remarks for the column. |
COLUMN_DEFAULT
|
VARCHAR |
The default value of the column. |
SQL_TYPE_ID
|
INTEGER |
The SQL data type of the column. |
SQL_DATETIME_SUB
|
VARCHAR |
The subtype for a datetime data type. This value has no meaning for non-datetime data types. |
CHAR_OCTET_LENGTH
|
INTEGER |
The maximum length of a string or binary data column. |
ORDINAL_POSITION
|
INTEGER |
Indicates the position of the column in the table definition. |
|
VARCHAR |
Values can be YES or NO, determined by the value of the NULLABLE column. |
|
BOOLEAN |
Indicates whether the column is a sequence, for example, an auto-increment column. |