DatabaseTableApplicationCreatedLinks
sybsystemprocssp_oledb_columns_rset_002   01 janv. 70Joins Schema ColumnUsage Queries Writes Propagation Dependencies

1     create table sp_oledb_columns_rset_002(-- 0 Rows, Data: 0 B, Index: 0 B
2         TABLE_CATALOG varchar(32) not null,
3         TABLE_SCHEMA varchar(32) not null,
4         TABLE_NAME varchar(255) not null,
5         COLUMN_NAME varchar(255) not null,
6         COLUMN_GUID varchar(36) not null,
7         COLUMN_PROPID int not null,
8         ORDINAL_POSITION int not null,
9         COLUMN_HASDEFAULT bit not null,
10        COLUMN_DEFAULT varchar(255) not null,
11        COLUMN_FLAGS int not null,
12        IS_NULLABLE bit not null,
13        TYPE_NAME varchar(255) not null,
14        TYPE_GUID varchar(36) not null,
15        CHARACTER_MAXIMUM_LENGTH int not null,
16        CHARACTER_OCTET_LENGTH int not null,
17        NUMERIC_PRECISION smallint not null,
18        NUMERIC_PRECISION_RADIX smallint not null,
19        NUMERIC_SCALE smallint not null,
20        DATETIME_PRECISION int not null,
21        CHARACTER_SET_CATALOG varchar(32) not null,
22        CHARACTER_SET_SCHEMA varchar(32) not null,
23        CHARACTER_SET_NAME varchar(255) not null,
24        COLLATION_CATALOG varchar(32) not null,
25        COLLATION_SCHEMA varchar(32) not null,
26        COLLATION_NAME varchar(32) not null,
27        DOMAIN_CATALOG varchar(32) not null,
28        DOMAIN_SCHEMA varchar(32) not null,
29        DOMAIN_NAME varchar(32) not null,
30        DESCRIPTION varchar(32) not null
31    )
32    
SCHEMA

QUERIES
Joined With Links

COLUMN WRITES detailed
ColumnWritten From
TABLE_CATALOG  sp_oledb_columns.@?  
TABLE_SCHEMA  sysobjects.uid   sp_oledb_columns.@?  
TABLE_NAME  sysobjects.name   sp_rename.@newname  
COLUMN_NAME  syscolumns.name   sp_rename.@newname  
COLUMN_GUID  sp_oledb_columns.@?  
COLUMN_PROPID  sp_oledb_columns.@?  
ORDINAL_POSITION  sp_oledb_columns.@?  
COLUMN_HASDEFAULT  systypes.tdefault   syscomments.id   syscolumns.cdefault   sp_unbindefault.@?   sp_oledb_columns.@?   sp_addtype.@?   sp_bindefault.@?   sp_bindefault.@defname  
COLUMN_DEFAULT  sp_oledb_columns.@?  
COLUMN_FLAGS  syscolumns.status   sp_unbindrule.@?   sp_rename.@?   sp_oledb_columns.@?   sp_setreplicate.@?   sp_bindrule.@?   sp_setreptable.@?  
IS_NULLABLE  syscolumns.status   sp_unbindrule.@?   sp_rename.@?   sp_oledb_columns.@?   sp_setreplicate.@?   sp_bindrule.@?   sp_setreptable.@?  
TYPE_NAME  spt_sybdrv.data_type   sp_oledb_columns.@?  
TYPE_GUID  sp_oledb_columns.@?  
CHARACTER_MAXIMUM_LENGTH  sp_oledb_columns.@?  
CHARACTER_OCTET_LENGTH  sp_oledb_columns.@?  
NUMERIC_PRECISION  syscolumns.prec   spt_datatype_info.data_precision   °.aux   syscolumns.length   spt_datatype_info.ss_dtype   sp_oledb_columns.@?  
NUMERIC_PRECISION_RADIX  sp_oledb_columns.@?  
NUMERIC_SCALE  syscolumns.scale   spt_datatype_info.numeric_scale   °.aux   syscolumns.length   spt_datatype_info.ss_dtype   sp_oledb_columns.@?  
DATETIME_PRECISION  sp_oledb_columns.@?  
CHARACTER_SET_CATALOG  sp_oledb_columns.@?  
CHARACTER_SET_SCHEMA  sp_oledb_columns.@?  
CHARACTER_SET_NAME  sp_oledb_columns.@?  
COLLATION_CATALOG  sp_oledb_columns.@?  
COLLATION_SCHEMA  sp_oledb_columns.@?  
COLLATION_NAME  sp_oledb_columns.@?  
DOMAIN_CATALOG  sp_oledb_columns.@?  
DOMAIN_SCHEMA  sp_oledb_columns.@?  
DOMAIN_NAME  sp_oledb_columns.@?  

DEPENDENCIES
READERS AND WRITERS
written by proc sybsystemprocs..sp_oledb_columns