How to interpret the value of sysconstraints.status?

Article View: comp.databases.ms-sqlserver

Article #46

Back to comp.databases.ms-sqlserver Previous Next

#46

From: 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.

Technical Details

Message-ID: <4d1rih$o1@unix2.glink.net.hk>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 104de1,b6d4ab8adae5291a,start
X-Google-Attributes: gid104de1,public
X-Google-Thread: f6611,b6d4ab8adae5291a,start
X-Google-Attributes: gidf6611,public
From: cypoon@glink.net.hk (Poon Chak Yau)
Subject: How to interpret the value of sysconstraints.status?
Date: 1996/01/11
Message-ID: <4d1rih$o1@unix2.glink.net.hk>
X-Deja-AN: 134669002
organization: Global Link Information Services Ltd.
newsgroups: comp.databases.ms-sqlserver,bit.databases.mssql-l