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 vote400 views1 answer
Sql basic commands
SQL
0 vote339 views4 answers
Sql limit 1 offset 1
SQL
5 votes298 views1 answer
Copy table from one database to another mysql
SQL
0 vote350 views1 answer
Test sql query
SQL
1 vote361 views1 answer
Mysql select and count left join
SQL
-1 vote359 views1 answer
Auto increment psql not primary key
SQL
3 votes394 views1 answer
Mysql group_concat distinct
SQL
0 vote333 views1 answer
Order by monthly in sql
SQL
1 vote335 views1 answer
Clear screen command in psql
SQL
1 vote325 views3 answers
Remove unique key from a table
SQL