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

1     create table sp_oledb_fkeys_rset_001(-- 0 Rows, Data: 0 B, Index: 0 B
2         PK_TABLE_CATALOG varchar(32) not null,
3         PK_TABLE_SCHEMA varchar(32) not null,
4         PK_TABLE_NAME varchar(255) not null,
5         PK_COLUMN_NAME varchar(255) not null,
6         PK_COLUMN_GUID varchar(36) not null,
7         PK_COLUMN_PROP_ID int not null,
8         FK_TABLE_CATALOG varchar(32) not null,
9         FK_TABLE_SCHEMA varchar(32) not null,
10        FK_TABLE_NAME varchar(255) not null,
11        FK_COLUMN_NAME varchar(255) not null,
12        FK_COLUMN_GUID varchar(36) not null,
13        FK_COLUMN_PROP_ID int not null,
14        ORDINAL int not null,
15        UPDATE_RULE varchar(32) not null,
16        DELETE_RULE varchar(32) not null,
17        FK_NAME varchar(255) not null,
18        PK_NAME varchar(255) not null,
19        DEFERRABILITY smallint not null
20    )
21    
SCHEMA

QUERIES
Joined With Links

COLUMN WRITES detailed
ColumnWritten From
PK_TABLE_CATALOG  sp_oledb_fkeys.@pktable_qualifier   sp_oledb_fkeys.@?  
PK_TABLE_SCHEMA  sysobjects.uid   sp_oledb_fkeys.@?  
PK_TABLE_NAME  sp_oledb_fkeys.@?  
PK_COLUMN_NAME  sp_oledb_fkeys.@?  
PK_COLUMN_GUID  sp_oledb_fkeys.@?  
PK_COLUMN_PROP_ID  sp_oledb_fkeys.@?  
FK_TABLE_CATALOG  sp_oledb_fkeys.@?   sp_oledb_fkeys.@fktable_qualifier  
FK_TABLE_SCHEMA  sysobjects.uid   sp_oledb_fkeys.@?  
FK_TABLE_NAME  sp_oledb_fkeys.@?  
FK_COLUMN_NAME  sp_oledb_fkeys.@?  
FK_COLUMN_GUID  sp_oledb_fkeys.@?  
FK_COLUMN_PROP_ID  sp_oledb_fkeys.@?  
ORDINAL  sp_oledb_fkeys.@?  
UPDATE_RULE  sp_oledb_fkeys.@?  
DELETE_RULE  sp_oledb_fkeys.@?  
FK_NAME  sp_oledb_fkeys.@?  
PK_NAME  sysindexes.name   sp_rename.@?   sp_rename.@newname  
DEFERRABILITY  sp_oledb_fkeys.@?  

DEPENDENCIES
READERS AND WRITERS
written by proc sybsystemprocs..sp_oledb_fkeys