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 vote113 views1 answer
Postgres can integer fields be negative
SQL
94 votes141 views4 answers
Create database postgres
SQL
0 vote113 views1 answer
Oracle dynamic select into
SQL
0 vote82 views1 answer
Sql table to store status
SQL
0 vote155 views1 answer
Sql query to select even numbers
SQL
0 vote123 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL
2 votes158 views1 answer
Tcl in sql
SQL
17 votes113 views6 answers
Mysql import sql file
SQL
0 vote127 views1 answer
Sql server sleep
SQL
1 vote117 views2 answers
OSError: mysql_config not found mysql_config --version mariadb_config --version mysql_config --libs ---------------------------------------- ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command outpu
SQL