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

36 votes225 views3 answers
Add column in mysq
SQL
7 votes172 views1 answer
Mysql load data infile csv
SQL
0 vote204 views1 answer
How to insert a uniqueidentifier in sql
SQL
0 vote214 views1 answer
Count characters of string mysql
SQL
0 vote196 views1 answer
Date diff sql
SQL
0 vote197 views2 answers
Sql use not in
SQL
0 vote183 views1 answer
Trim sql oracle
SQL
0 vote239 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
0 vote222 views1 answer
Learnxinyminutes sql
SQL
244 votes508 views14 answers
Sql n insert
SQL