What are the different types of Constraints in SQL Server?
Introduction:
In this article i will explain what is Constraint. And how many Constraints available in SQL Server.
Description:
In previous articles i explained Temporary Table and other SQL Server topics. Now i will explain what is Constraint. And how many Constraints available in SQL Server.
Constraint:
A Constarint is condition which is imposed on the data. Constraints define rules regarding the values allowed in columns and are the standard mechanism for enforcing integrity.
SQL Server supports the following classes of constraints:
Note:
The query optimizer also uses constraint definitions to build high-performance query execution plans.
-
CreatedOct 17, 2013
-
UpdatedOct 03, 2020
-
Views622
Related Articles
What is the difference between Stored Procedure and Function in SQL Server
What is Cross Join in SQL Server
How delete record from parent table when there is Foreign Key relation in SQL Server
What is the differences between CHAR, NCHAR, VARCHAR and NVARCHAR in SQL Server?
How to use Delete Command in SQL Server?
How to insert values into Identity Column in SQL Server?
How to get a fixed-length value in SQL Server?
What is Left Join (or) Left Outer Join in SQL Server?
How to get current week dates in SQL Server?
What are the different types of Date formats in SQL Server?