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 User DB System Tables.


Updated: Sun Sep 29 12:52:00 2002