In this article i will explain what is Constraint. And how many Constraints available in SQL Server.
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:
The query optimizer also uses constraint definitions to build high-performance query execution plans.