sp_columns

Returns information about the type of data that can be stored in one or more columns.

Syntax

sp_columns table_name [, table_owner]
 [, table_qualifier] [, column_name]

table_name – is the table name or view. Use the wildcard character to request information about more than one table.
table_owner – is the owner of the table or view. Use the wildcard character to request information about tables owned by more than one user.
table_qualifier – is ignored. Leave blank or set to NULL.
column_name – is the name of the column for which you want information. Use the wildcard character to request information about more than one column.

This procedure returns the Adaptive Server datatype that most clearly matches the native datatype of the target, regardless of the current datatype properties.
This procedure corresponds to the ODBC function SQLColumns.
This procedure returns one row containing a description of each column in a table.
- There are three columns in the result set that describe each datatype; TYPE_NAME, DATA_TYPE, and REMOTE_DATA_TYPE.
- TYPE_NAME contains the ODBC datatype name and DATA_TYPE contains the ODBC integer identifier.
- The REMOTE_DATA_TYPE column contains a 32-bit or 4-byte composite user datatype UDT specifically identifying the remote datatype.
This procedure allows transmission of column datatypes using a target-specific-type ID. The REMOTE_DATA_TYPE column contains a 32-bit composite datatype defined by the access service.