How to interpret the value of sysconstraints.status?

Thread View: comp.databases.ms-sqlserver

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Poon Chak Yau Thu, 11 Jan 1996 00:00

#46

Author: Poon Chak Yau
Date: Thu, 11 Jan 1996 00:00

17 lines
944 bytes

Hello,
	I read from the SQL Server Books Online that the sysconstraints.status
has type int and the description of it is:
1 Primary Key constraint.
2 Unique Key constraint.
3 Foreign Key constraint.
4 Check constraint.
5 Default constraint.
16 Column-level constraint.
32 Table-level constraint.

What does the final integer value get if it has more than one type of
constraint?

Thank you!

Poon Chak Yau.

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads