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 votes137 views4 answers
Postgresql change timezone on timestamp without timezone
SQL
0 vote152 views3 answers
Constraint sql
SQL
0 vote150 views1 answer
On delete set default
SQL
0 vote142 views1 answer
Providername system.data. mysql
SQL
0 vote136 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL
2 votes134 views1 answer
Express api ith mysql data
SQL
6 votes127 views4 answers
Sqlite drop table
SQL
-1 vote138 views1 answer
How to create foreign key in sql server management studio
SQL
1 vote152 views1 answer
Opensuse restart MySQL
SQL
0 vote142 views1 answer
Android studio SQLiteDatabase delete all data in database
SQL