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

3 votes277 views1 answer
Fk in insert mysql
SQL
0 vote268 views1 answer
Turn on foreign keys check mysql
SQL
0 vote253 views1 answer
Get duplicate entry sql
SQL
2 votes287 views1 answer
Merge firstname and lastname in sql oracle
SQL
33 votes277 views6 answers
Change column name in mysql
SQL
2 votes283 views1 answer
Postgresql resolv duplicate value violates unique constraint
SQL
1 vote254 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
1 vote277 views1 answer
Get table column names sql ssms
SQL
0 vote276 views1 answer
Mysql get date diff in months
SQL
1 vote249 views1 answer
Mysql collation
SQL