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

1     create table sp_oledb_getprocedurecolumns_rset_002(-- 0 Rows, Data: 0 B, Index: 0 B
2         PROCEDURE_CATALOG varchar(32) not null,
3         PROCEDURE_SCHEMA varchar(32) not null,
4         PROCEDURE_NAME varchar(255) not null,
5         PARAMETER_NAME varchar(255) not null,
6         ORDINAL_POSITION smallint not null,
7         PARAMETER_TYPE smallint not null,
8         PARAMETER_HASDEFAULT bit not null,
9         PARAMETER_DEFAULT varchar(255) not null,
10        IS_NULLABLE bit not null,
11        DATA_TYPE smallint not null,
12        CHARACTER_MAXIMUM_LENGTH int not null,
13        CHARACTER_OCTET_LENGTH int not null,
14        NUMERIC_PRECISION smallint not null,
15        NUMERIC_SCALE smallint not null,
16        DESCRIPTION varchar(255) not null,
17        TYPE_NAME varchar(32) not null,
18        LOCAL_TYPE_NAME varchar(32) not null
19    )
20    
SCHEMA

QUERIES
Joined With Links

COLUMN WRITES detailed
ColumnWritten From
PROCEDURE_CATALOG  sp_oledb_getprocedurecolumns.@?  
PROCEDURE_SCHEMA  sysobjects.uid   sp_oledb_getprocedurecolumns.@?  
PROCEDURE_NAME  sysobjects.name   sp_rename.@newname  
PARAMETER_NAME  syscolumns.name   sp_rename.@newname   sp_oledb_getprocedurecolumns.@?  
ORDINAL_POSITION  syscolumns.colid   sp_oledb_getprocedurecolumns.@?  
PARAMETER_TYPE  sp_oledb_getprocedurecolumns.@?  
PARAMETER_HASDEFAULT  sp_oledb_getprocedurecolumns.@?  
PARAMETER_DEFAULT  sp_oledb_getprocedurecolumns.@?  
IS_NULLABLE  sp_oledb_getprocedurecolumns.@?  
DATA_TYPE  spt_sybdrv.data_type   sp_oledb_getprocedurecolumns.@?  
CHARACTER_MAXIMUM_LENGTH  syscolumns.prec   spt_datatype_info.data_precision   °.aux   syscolumns.length   spt_datatype_info.ss_dtype   sp_oledb_getprocedurecolumns.@?  
CHARACTER_OCTET_LENGTH  syscolumns.type   °.prec   spt_datatype_info.data_precision   °.aux   syscolumns.length   spt_datatype_info.ss_dtype   sp_oledb_getprocedurecolumns.@?  
NUMERIC_PRECISION  spt_datatype_info.data_precision  
NUMERIC_SCALE  spt_datatype_info.numeric_radix  
DESCRIPTION  syscolumns.scale   spt_datatype_info.numeric_scale   °.aux   syscolumns.length   spt_datatype_info.ss_dtype   sp_oledb_getprocedurecolumns.@?  
TYPE_NAME  sp_oledb_getprocedurecolumns.@?  
LOCAL_TYPE_NAME  spt_datatype_info.type_name   °.aux   syscolumns.length   spt_datatype_info.ss_dtype   sp_oledb_getprocedurecolumns.@?  

DEPENDENCIES
READERS AND WRITERS
written by proc sybsystemprocs..sp_oledb_getprocedurecolumns