SQL Server Performance

SQL Server TSQL to find detailed CONSTRAINTS information

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Sep 30, 2010.

  1. Anonymous New Member

    TO enforce the integrity of the data in the columns, CONSTRAINTS are very useful. In this regard SQL Server provides various mechanims in enforcing such integrity: PRIMARY KEY Constraints FOREIGN KEY Constraints UNIQUE Constraints CHECK Constraints DEFAULT Definitions Allowing Null Values Further steps are required in the database design to identify valid values for a column and to decide how to enforce the integrity of the data in the column. Data integrity falls into the following categories: Entity...(<a href="http://sqlserver-qa.net/blogs/t-sql/archive/2010/10/01/9628.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=9628" width="1" height="1">

Share This Page