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

1     create table #ofkey_res(-- 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_PROP_ID int null,
7         FK_TABLE_CATALOG varchar(32) not null,
8         FK_TABLE_SCHEMA varchar(32) not null,
9         FK_TABLE_NAME varchar(255) not null,
10        FK_COLUMN_NAME varchar(255) not null,
11        FK_COLUMN_PROP_ID int null,
12        ORDINAL int not null,
13        UPDATE_RULE varchar(32) not null,
14        DELETE_RULE varchar(32) not null,
15        FK_NAME varchar(255) not null,
16        PK_NAME varchar(255) not null,
17        DEFERRABILITY smallint not null
18    )
19    
COLUMN USAGE
PK_TABLE_CATALOGsp_oledb_fkeys 
PK_TABLE_SCHEMAsp_oledb_fkeys 
PK_TABLE_NAMEsp_oledb_fkeys 
PK_COLUMN_NAMEsp_oledb_fkeys 
PK_COLUMN_PROP_IDsp_oledb_fkeys 
FK_TABLE_CATALOGsp_oledb_fkeys 
FK_TABLE_SCHEMAsp_oledb_fkeys 
FK_TABLE_NAMEsp_oledb_fkeys 
FK_COLUMN_NAMEsp_oledb_fkeys 
FK_COLUMN_PROP_IDsp_oledb_fkeys 
ORDINALsp_oledb_fkeys 
UPDATE_RULEsp_oledb_fkeys 
DELETE_RULEsp_oledb_fkeys 
FK_NAMEsp_oledb_fkeys 
PK_NAMEsp_oledb_fkeys 
DEFERRABILITYsp_oledb_fkeys 

QUERIES
Joined With Links

DEPENDENCIES
READERS AND WRITERS
read_written by proc sybsystemprocs..sp_oledb_fkeys