ColumnsColumns Class

Column names for result table from built-in stored procedure DB_ADMIN.GET_COLUMNS and DataStoreConnection.GetSchema(MetaDataCollectionName.Columns)

Class Hierarchy

Pascal

ColumnsColumns = class;

C++

class ColumnsColumns;

File

ColumnsColumns.cs

Description

ColumnsColumns provides the column names for the result table from the built-in stored procedure DB_ADMIN.GET_COLUMNS and DataStoreConnection.GetSchema(MetaDataCollectionName.Columns). Each row in the result table of DB_ADMIN.GET_COLUMNS describes a column from a table in a database.

The columns of the result table are:

Constant	Description
CatalogName	Used to access the CatalogName column in the Columns metadata collection. The data in this column specifies the catalog name.
SchemaName	Used to access the SchemaName column in the Columns metadata collection. The data in this column specifies the schema name.
TableName	Used to access the TableName column in the Columns metadata collection. The data in this column specifies the table name.
ColumnName	Used to access the ColumnName column in the Columns metadata collection. The data in this column specifies the column name.
TypeName	Used to access the TypeName column in the Columns metadata collection. The data in this column specifies the database specific data type name.
Precision	Used to access the Precision column in the Columns metadata collection.The data in this column specifies the precision of this type. For a string data type, this is the maximum number of characters. For a decimal types, this is the maximum number digits including digits from the scale.
Scale	Used to access the Scale column in the Columns metadata collection. The data in this column specifies the scale of a decimal type.
Ordinal	Used to access the Ordinal column in the Columns metadata collection. The data in this column specifies the position in the columns of the table starting with 1.
DefaultValue	Used to access the DefaultValue column in the Columns metadata collection. The data in this column specifies the default value.
IsNullable	Used to access the IsNullable column in the Columns metadata collection. The data in this column specifies that the column can accept NULL values.
IsAutoIncrement	Used to access the IsAutoIncrement column in the Columns metadata collection. The data in this column specifies that the column is an autoincrement value.
MaxInline	Used to access the MaxInline column in the Columns metadata collection. The data in this column specifies the maximal number of bytes to write into row. The rest of the data is handled as a blob (Blackfish SQL only).
DbxDataType	Used to access the DbxDataType column in the Columns metadata collection. The data in this column specifies the DBX data type.
IsFixedLength	Used to access the IsFixedLength column in the EndColumns metadata collection.The data in this column specifies that the column holds fixed length data.
IsUnicode	Used to access the IsUnicode column in the Columns metadata collection. The data in this column specifies that the column can hold unicode characters.
IsLong	Used to access the IsLong column in the Columns metadata collection. The data in this column specifies that the column is a blob data type.
IsUnsigned	Used to access the IsUnsigned column in the Columns metadata collection. The data in this column specifies that the column is an unsigned numeric type.