Check constraint in ms sql

Check constraint in sql

CREATE TABLE Persons (
    ID int NOT NULL,
    LastName varchar(255) NOT NULL,
    FirstName varchar(255),
    Age int,
    City varchar(255),
    CONSTRAINT CHK_Person CHECK (Age>=18 AND City='Sandnes')
);

Check constraint in sql

#For one column
CREATE TABLE Persons (
    ID int NOT NULL,
    LastName varchar(255) NOT NULL,
    FirstName varchar(255),
    Age int CHECK (Age>=18)
);

Check constraint in sql

#Add Check
ALTER TABLE Persons
ADD CONSTRAINT CHK_PersonAge CHECK (Age>=18 AND City='Sandnes');

#Drop Check 
ALTER TABLE Persons
DROP CHECK CHK_PersonAge;

Check constraint in ms sql

/*Adding Check constraint in sql server*/
ALTER TABLE (Table_Name)
ADD CONSTRAINT (Constraint_Name) CHECK (Boolean_Expression)

Similar codes

0 vote315 views1 answer
Sql search all columns of database oracle sql
SQL
3 votes346 views1 answer
Postgresql if null then 0
SQL
-1 vote319 views1 answer
Add bool column in sql
SQL
0 vote290 views1 answer
Create duplicate table in postgresql
SQL
21 votes319 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
0 vote326 views2 answers
Mysql dump structure only
SQL
28 votes372 views6 answers
Sql update
SQL
15 votes306 views2 answers
How to drop database name in postgresql
SQL
15 votes317 views6 answers
Drop foreign key mysql
SQL
0 vote335 views1 answer
Hibernate show sql xml property
SQL