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 vote213 views3 answers
Django.core.exceptions.improperlyconfigured: error loading mysqldb module. mac
SQL
4 votes251 views2 answers
Could not find driver (SQL: select * from information_schema.tables where table_schema = pics and table_name = migrations and table_type = 'BASE TABLE')
SQL
25 votes268 views4 answers
Sqlserver add column
SQL
2 votes270 views1 answer
Mysql create user with remote access
SQL
16 votes275 views3 answers
Update table from another table
SQL
0 vote249 views1 answer
Oracle exchange subpartition
SQL
0 vote269 views1 answer
Can we rollback in sql
SQL
0 vote270 views1 answer
Oracle concat datetime
SQL
0 vote291 views1 answer
Sql script to remove default from column
SQL
24 votes265 views5 answers
Import dump mysql
SQL