1     create table #jdbc_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(257) null,
5         COLUMN_NAME varchar(257) 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 int null,
11        NUM_PREC_RADIX int null,
12        NULLABLE int null,
13        REMARKS varchar(255) null,
14        COLUMN_DEF varchar(512) null,
15        SQL_DATA_TYPE int null,
16        SQL_DATETIME_SUB int null,
17        CHAR_OCTET_LENGTH int null,
18        ORDINAL_POSITION int null,
19        IS_NULLABLE varchar(10) null,
20        SCOPE_CATLOG varchar(32) null,
21        SCOPE_SCHEMA varchar(32) null,
22        SCOPE_TABLE varchar(32) null,
23        SOURCE_DATA_TYPE smallint null,
24        IS_AUTOINCREMENT varchar(10) null
25    )
26    

DEPENDENCIES

READERS AND WRITERS read_written by proc sybsystemprocs..sp_jdbc_columns