Wednesday , January 17 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

Find all rows count and columns count in single database in sql server

In General for any database it contains lot of tables, if we want to find …

%d bloggers like this: