Database	Table	Application	Created	Links
sybsystemprocs	sysreferences		31 Aug 14	Joins Schema ColumnUsage Queries Dependencies

1     create table sysreferences(-- 0 Rows, Data: 2 KB, Index: 8 KB
2         indexid smallint not null,
3         constrid int not null,
4         tableid int not null,
5         reftabid int not null,
6         keycnt smallint not null,
7         status smallint not null,
8         frgndbid smallint not null,
9         pmrydbid smallint not null,
10        spare2 int not null,
11        fokey1 smallint not null,
12        fokey2 smallint not null,
13        fokey3 smallint not null,
14        fokey4 smallint not null,
15        fokey5 smallint not null,
16        fokey6 smallint not null,
17        fokey7 smallint not null,
18        fokey8 smallint not null,
19        fokey9 smallint not null,
20        fokey10 smallint not null,
21        fokey11 smallint not null,
22        fokey12 smallint not null,
23        fokey13 smallint not null,
24        fokey14 smallint not null,
25        fokey15 smallint not null,
26        fokey16 smallint not null,
27        refkey1 smallint not null,
28        refkey2 smallint not null,
29        refkey3 smallint not null,
30        refkey4 smallint not null,
31        refkey5 smallint not null,
32        refkey6 smallint not null,
33        refkey7 smallint not null,
34        refkey8 smallint not null,
35        refkey9 smallint not null,
36        refkey10 smallint not null,
37        refkey11 smallint not null,
38        refkey12 smallint not null,
39        refkey13 smallint not null,
40        refkey14 smallint not null,
41        refkey15 smallint not null,
42        refkey16 smallint not null,
43        frgndbname varchar(30) null,
44        pmrydbname varchar(30) null
45    )
46    
47    create clustered index csysreferences on sysreferences(-- 2 KB refcount: 8
48        tableid, frgndbname
49    )
50    create index nc2sysreferences on sysreferences(-- 2 KB refcount: 3
51        reftabid, indexid, pmrydbname
52    )
53    create index ncsysreferences on sysreferences(-- 2 KB refcount: 0
54        constrid, frgndbname
55    )
56    
57    alter table sysreferences lock datarows
58    
59    Grant Select on sysreferences to public
60    

SCHEMA

DEPENDENCIES

READERS AND WRITERS read by proc sybsystemprocs..sp_oledb_fkeys   read by proc sybsystemprocs..sp_odbc_fkeys   read by proc sybsystemprocs..sp_fkeys   read by proc sybsystemprocs..sp_helpconstraint   read by proc sybsystemprocs..sp_jdbc_fkeys      called by proc sybsystemprocs..sp_jdbc_getcrossreferences      called by proc sybsystemprocs..sp_jdbc_exportkey      called by proc sybsystemprocs..sp_jdbc_importkey   read by proc sybsystemprocs..sp_depends_cols      called by proc sybsystemprocs..sp_depends   read by proc sybsystemprocs..sp_ijdbc_fkeys      called by proc sybsystemprocs..sp_ijdbc_getcrossreferences      called by proc sybsystemprocs..sp_ijdbc_exportkey      called by proc sybsystemprocs..sp_ijdbc_importkey