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 vote142 views1 answer
Sql decode
SQL
3 votes150 views1 answer
Increment integer in table sql
SQL
0 vote150 views2 answers
Starts and end with vowel sql
SQL
0 vote89 views1 answer
Update row in sqlite python
SQL
0 vote140 views1 answer
Cursor.execute (sql, value) ValueError: operation parameter must be str
SQL
-1 vote159 views5 answers
Operator in sql
SQL
10 votes103 views2 answers
Mysql select timestamp group by day
SQL
0 vote142 views2 answers
Oracle chain rules
SQL
0 vote132 views1 answer
Mariadb number format
SQL
0 vote141 views1 answer
Create mysql pool connection python flask
SQL