sysconstraints

Columns for sysconstraints

#

Column

Datatype

Len

Prec

Scale

Null

Default

Rule

Comments

1

colid

smallint

2

 

 

No

 

 

 

2

constrid

int

4

 

 

No

 

 

 

3

tableid

int

4

 

 

No

 

 

 

4

error

int

4

 

 

No

 

 

 

5

status

int

4

 

 

No

 

 

 

6

spare2

int

4

 

 

No

 

 

 

 

Indexes for sysconstraints

Name

Attributes

Segment

Columns

csysconstraints

clustered

system

tableid, colid

ncsysconstraints


unique

system

constrid

 

Permissions on sysconstraints

#

User/Group

Protect-Type

Action

Column Mask

Grantor

1

public

grant

select

All

dbo

 


Go to Sybase 12.5.2 Master Database List of Tables.


Updated: Sun Dec 26 14:50:04 2004