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

1     create table sp_datatype_info_rset_001(-- 0 Rows, Data: 0 B, Index: 0 B
2         type_name varchar(9) not null,
3         data_type smallint not null,
4         precison int not null,
5         literal_prefix varchar(32) not null,
6         literal_suffix varchar(32) not null,
7         create_params varchar(32) not null,
8         nullable smallint not null,
9         case_sensitive smallint not null,
10        searchable smallint not null,
11        unsigned_attribute smallint not null,
12        money smallint not null,
13        auto_increment smallint not null,
14        local_type_name varchar(128) not null,
15        minimum_scale smallint not null,
16        maximum_scale smallint not null,
17        sql_data_type smallint not null,
18        sql_datetime_sub smallint not null,
19        num_prec_radix smallint not null,
20        interval_precision smallint not null
21    )
22    
SCHEMA

QUERIES
Joined With Links

COLUMN WRITES detailed
ColumnWritten From
type_name  systypes.name   sp_rename.@newname   sp_datatype_info.@?   sp_addtype.@typename  
data_type  spt_datatype_info.data_type  
precison  systypes.length   spt_datatype_info.data_precision   sp_datatype_info.@?   sp_addtype.@?   sp_addtype.@phystype  
literal_prefix  spt_datatype_info.literal_prefix  
literal_suffix  spt_datatype_info.literal_suffix  
create_params  spt_datatype_info_ext.create_params  
nullable  spt_datatype_info.nullable  
case_sensitive  spt_datatype_info.case_sensitive  
searchable  spt_datatype_info.searchable  
unsigned_attribute  spt_datatype_info.unsigned_attribute  
money  spt_datatype_info.money  
auto_increment  spt_datatype_info.auto_increment  
local_type_name  spt_datatype_info.local_type_name  
minimum_scale  spt_datatype_info.sql_data_type  
maximum_scale  spt_datatype_info.sql_datetime_sub  
sql_data_type  spt_datatype_info.num_prec_radix  
sql_datetime_sub  spt_datatype_info.interval_precision  

DEPENDENCIES
READERS AND WRITERS
written by proc sybsystemprocs..sp_datatype_info