|
# |
Column |
Datatype |
Len |
Prec |
Scale |
Null |
Default |
Rule |
Comments |
|
1 |
indexid |
smallint |
2 |
|
|
No |
|
|
|
|
2 |
constrid |
int |
4 |
|
|
No |
|
|
|
|
3 |
tableid |
int |
4 |
|
|
No |
|
|
|
|
4 |
reftabid |
int |
4 |
|
|
No |
|
|
|
|
5 |
keycnt |
smallint |
2 |
|
|
No |
|
|
|
|
6 |
status |
smallint |
2 |
|
|
No |
|
|
|
|
7 |
frgndbid |
smallint |
2 |
|
|
No |
|
|
|
|
8 |
pmrydbid |
smallint |
2 |
|
|
No |
|
|
|
|
9 |
spare2 |
int |
4 |
|
|
No |
|
|
|
|
10 |
fokey1 |
smallint |
2 |
|
|
No |
|
|
|
|
11 |
fokey2 |
smallint |
2 |
|
|
No |
|
|
|
|
12 |
fokey3 |
smallint |
2 |
|
|
No |
|
|
|
|
13 |
fokey4 |
smallint |
2 |
|
|
No |
|
|
|
|
14 |
fokey5 |
smallint |
2 |
|
|
No |
|
|
|
|
15 |
fokey6 |
smallint |
2 |
|
|
No |
|
|
|
|
16 |
fokey7 |
smallint |
2 |
|
|
No |
|
|
|
|
17 |
fokey8 |
smallint |
2 |
|
|
No |
|
|
|
|
18 |
fokey9 |
smallint |
2 |
|
|
No |
|
|
|
|
19 |
fokey10 |
smallint |
2 |
|
|
No |
|
|
|
|
20 |
fokey11 |
smallint |
2 |
|
|
No |
|
|
|
|
21 |
fokey12 |
smallint |
2 |
|
|
No |
|
|
|
|
22 |
fokey13 |
smallint |
2 |
|
|
No |
|
|
|
|
23 |
fokey14 |
smallint |
2 |
|
|
No |
|
|
|
|
24 |
fokey15 |
smallint |
2 |
|
|
No |
|
|
|
|
25 |
fokey16 |
smallint |
2 |
|
|
No |
|
|
|
|
26 |
refkey1 |
smallint |
2 |
|
|
No |
|
|
|
|
27 |
refkey2 |
smallint |
2 |
|
|
No |
|
|
|
|
28 |
refkey3 |
smallint |
2 |
|
|
No |
|
|
|
|
29 |
refkey4 |
smallint |
2 |
|
|
No |
|
|
|
|
30 |
refkey5 |
smallint |
2 |
|
|
No |
|
|
|
|
31 |
refkey6 |
smallint |
2 |
|
|
No |
|
|
|
|
32 |
refkey7 |
smallint |
2 |
|
|
No |
|
|
|
|
33 |
refkey8 |
smallint |
2 |
|
|
No |
|
|
|
|
34 |
refkey9 |
smallint |
2 |
|
|
No |
|
|
|
|
35 |
refkey10 |
smallint |
2 |
|
|
No |
|
|
|
|
36 |
refkey11 |
smallint |
2 |
|
|
No |
|
|
|
|
37 |
refkey12 |
smallint |
2 |
|
|
No |
|
|
|
|
38 |
refkey13 |
smallint |
2 |
|
|
No |
|
|
|
|
39 |
refkey14 |
smallint |
2 |
|
|
No |
|
|
|
|
40 |
refkey15 |
smallint |
2 |
|
|
No |
|
|
|
|
41 |
refkey16 |
smallint |
2 |
|
|
No |
|
|
|
|
42 |
frgndbname |
varchar |
30 |
|
|
Yes |
|
|
|
|
43 |
pmrydbname |
varchar |
30 |
|
|
Yes |
|
|
|
|
Name |
Attributes |
Segment |
Columns |
|
csysreferences |
clustered |
default |
tableid, frgndbname |
|
ncsysreferences |
|
default |
constrid, frgndbname |
|
nc2sysreferences |
|
default |
reftabid, indexid, pmrydbname |
|
# |
User/Group |
Protect-Type |
Action |
Column Mask |
Grantor |
|
1 |
public |
grant |
select |
All |
dbo |
Go to Sybase 12.5 User DB System Tables.
Updated: Sun Sep 29 12:52:00 2002