Thursday , October 18 2018
Home / DataBase / SQL SERVER / Create Check Constraint in Sql Server

Create Check Constraint in Sql Server

Create Check Constraint in Sql Server

Check Constraint: If we want to check the values present in a column to be according to a specified value we use this constraint.

Syntax:

 

 

Example:

Explanation: The Above Example Explains you the Employee salary Should be more than 1000 .If you are trying to insert salary less than 1000 it will give error.

Print Friendly, PDF & Email

Give us your valuable feedback

comments

About Samba

Check Also

sql server backup script

Backup all databases in SQL Instance with one script

Backup: A copy of SQL Server data that can be used to restore and recover the …