1     create table #odbc_columns(-- 0 Rows, Data: 0 B, Index: 0 B
2         TABLE_CAT varchar(32) null,
3         TABLE_SCHEM varchar(32) null,
4         TABLE_NAME varchar(255) null,
5         COLUMN_NAME varchar(255) null,
6         DATA_TYPE smallint null,
7         TYPE_NAME varchar(255) null,
8         COLUMN_SIZE int null,
9         BUFFER_LENGTH int null,
10        DECIMAL_DIGITS smallint null,
11        NUM_PREC_RADIX smallint null,
12        NULLABLE smallint null,
13        REMARKS varchar(255) null,
14        COLUMN_DEF varchar(512) null,
15        SQL_DATA_TYPE smallint null,
16        SQL_DATETIME_SUB smallint null,
17        CHAR_OCTET_LENGTH int null,
18        ORDINAL_POSITION int null,
19        IS_NULLABLE varchar(10) null
20    )
21    

DEPENDENCIES

READERS AND WRITERS read_written by proc sybsystemprocs..sp_odbc_columns