DatabaseTableApplicationCreatedLinks
tempdb#results_table_crby_sybsystemprocs__sp_oledb_columns  01 Jan 70Joins Schema ColumnUsage Queries Dependencies

1     create table #results_table(-- 0 Rows, Data: 0 B, Index: 0 B
2         TABLE_CATALOG varchar(32) null,
3         TABLE_SCHEMA varchar(32) null,
4         TABLE_NAME varchar(255) null,
5         COLUMN_NAME varchar(255) null,
6         COLUMN_GUID varchar(36) null,
7         COLUMN_PROPID int null,
8         ORDINAL_POSITION int null,
9         COLUMN_HASDEFAULT bit not null,
10        COLUMN_DEFAULT varchar(255) null,
11        COLUMN_FLAGS int null,
12        usertype int null,
13        IS_NULLABLE bit not null,
14        DATA_TYPE smallint null,
15        TYPE_GUID varchar(36) null,
16        CHARACTER_MAXIMUM_LENGTH int null,
17        CHARACTER_OCTET_LENGTH int null,
18        NUMERIC_PRECISION smallint null,
19        NUMERIC_PRECISION_RADIX smallint null,
20        TYPE_NAME varchar(255) null,
21        NUMERIC_SCALE smallint null,
22        DATETIME_PRECISION int null,
23        CHARACTER_SET_CATALOG varchar(32) null,
24        CHARACTER_SET_SCHEMA varchar(32) null,
25        CHARACTER_SET_NAME varchar(255) null,
26        COLLATION_CATALOG varchar(32) null,
27        COLLATION_SCHEMA varchar(32) null,
28        COLLATION_NAME varchar(32) null,
29        DOMAIN_CATALOG varchar(32) null,
30        DOMAIN_SCHEMA varchar(32) null,
31        DOMAIN_NAME varchar(32) null,
32        DESCRIPTION varchar(32) null,
33        tds_type smallint null,
34        id int null,
35        col_len int null,
36        sys_type smallint null,
37        row_id numeric(10, 0) identity not null
38    )
39    
COLUMN USAGE
TABLE_CATALOGsp_oledb_columns 
TABLE_SCHEMAsp_oledb_columns 
TABLE_NAMEsp_oledb_columns 
COLUMN_NAMEsp_oledb_columns 
COLUMN_GUIDsp_oledb_columns 
COLUMN_PROPIDsp_oledb_columns 
ORDINAL_POSITIONsp_oledb_columns 
COLUMN_HASDEFAULTsp_oledb_columns 
COLUMN_DEFAULTsp_oledb_columns 
COLUMN_FLAGSsp_oledb_columns 
usertypesp_oledb_columns 
IS_NULLABLEsp_oledb_columns 
DATA_TYPEsp_oledb_columns 
TYPE_GUIDsp_oledb_columns 
CHARACTER_MAXIMUM_LENGTHsp_oledb_columns 
CHARACTER_OCTET_LENGTHsp_oledb_columns 
NUMERIC_PRECISIONsp_oledb_columns 
NUMERIC_PRECISION_RADIXsp_oledb_columns 
TYPE_NAMEsp_oledb_columns 
NUMERIC_SCALEsp_oledb_columns 
DATETIME_PRECISIONsp_oledb_columns 
CHARACTER_SET_CATALOGsp_oledb_columns 
CHARACTER_SET_SCHEMAsp_oledb_columns 
CHARACTER_SET_NAMEsp_oledb_columns 
COLLATION_CATALOGsp_oledb_columns 
COLLATION_SCHEMAsp_oledb_columns 
COLLATION_NAMEsp_oledb_columns 
DOMAIN_CATALOGsp_oledb_columns 
DOMAIN_SCHEMAsp_oledb_columns 
DOMAIN_NAMEsp_oledb_columns 
DESCRIPTIONsp_oledb_columns 
tds_typesp_oledb_columns 
idsp_oledb_columns 
col_lensp_oledb_columns 
sys_typesp_oledb_columns 
row_idsp_oledb_columns 

QUERIES
Joined With Links

DEPENDENCIES
READERS AND WRITERS
read_written by proc sybsystemprocs..sp_oledb_columns