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 vote112 views1 answer
Search starting with mysql
SQL
2 votes112 views2 answers
Microsoft sql server extract hour and minute from datetime
SQL
6 votes166 views1 answer
Sql insert values into table
SQL
4 votes103 views1 answer
Add constraint fk
SQL
0 vote96 views1 answer
Frename oracle
SQL
20 votes103 views4 answers
Reset auto increment in MySQL
SQL
18 votes105 views2 answers
Sql inner join
SQL
0 vote107 views1 answer
Oracle archivemode
SQL
1 vote73 views5 answers
Spring boot sql logging
SQL
0 vote107 views1 answer
How to set all the min and sec data to zero in sql server
SQL