The EnumColumns method returns a QueryResults object enumerating the columns of tables defined on a linked server.
object.EnumColumns( [ TableName ] , [ SchemaName ] , [ CatalogName ]
, [ ColumnName ] ) as QueryResults
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list. |
| TableName | Optional. String naming a table defined on the linked server. When specified, it restricts result set membership to the columns defined in the specified table. |
| SchemaName | Optional. String naming a schema on which the linked server table is defined. When specified, it restricts result set membership to the columns of tables defined on the schema |
| CatalogName | Optional. String naming a catalog on which the linked server table is defined. When specified, it restricts result set membership to the columns of tables defined on the catalog |
| ColumnName | Optional. String naming a column on a table named by the TableName argument. When specified, it restricts result set membership, returning a single row enumerating the column named. |
A QueryResults object containing one result set defined by these columns.
| Column | Data type | Description |
|---|---|---|
| TABLE_CAT | nvarchar(128) | Name of the Microsoft® SQL Server™ database in which the column is defined. |
| TABLE_SCHEM | nvarchar(128) | Name of the owner of the table in which the column is defined. |
| TABLE_NAME | nvarchar(128) | Name of the table in which the column is defined. |
| COLUMN_NAME | nvarchar(128) | Name of the column. |
| DATA_TYPE | smallint | Data type of the column. Interpret the value using SQLDMO_QUERY_ DATATYPE. |
| TYPE_NAME | nvarchar(128) | Name of the column data type. |
| COLUMN_SIZE | integer | When the data type is a fixed or variable-length character or binary type, the number of characters or bytes. When the data type is a fixed-precision numeric type, the precision of the data type. |
| BUFFER_LENGTH | integer | When the data type is a fixed or variable-length character or binary type, the number of bytes required to retrieve any value from the column. |
| DECIMAL_DIGITS | smallint | When the data type is a fixed-precision numeric type, the scale of the data type. |
| NUM_PREC_RADIX | smallint | Radix of a numeric data type. |
| NULLABLE | smallint | 1 when the column accepts NULL. 0 when the column does not accept NULL. |
| REMARKS | nvarchar(256) | Descriptive text. |
| COLUMN_DEF | nvarchar(128) | Default value. |
| SQL_DATA_TYPE | smallint | Data type of the column. Interpret the value using SQLDMO_QUERY_ DATATYPE. |
| SQL_DATETIME_ SUB |
smallint | Subtype code for SQL-92 date, time, and interval data types. |
| CHAR_OCTET_ LENGTH |
integer | Maximum length in bytes of a character data type. |
| ORDINAL_ POSITION |
smallint | Ordinal position of the column in the table. |
| IS_NULLABLE | char(10) | YES when the column may contain NULL. NO when the column cannot contain NULL. |
| SS_DATA_TYPE | tinyint | SQL Server data type interpreted by using data type constants defined by Open Data Services. |
HRESULT EnumColumns(LPSQLDMOQUERYRESULTS *ppResults,
SQLDMO_LPCSTR TableName = NULL,
SQLDMO_LPCSTR SchemaName = NULL,
SQLDMO_LPCSTR CatalogName = NULL,
SQLDMO_LPCSTR ColumnName = NULL);