The CHECK constraint is used to limit the value range that can be placed in a column.
If you define a CHECK constraint on a single column it allows only certain values for this column. If you define a CHECK constraint on a table it can limit the values in certain columns based on values in other columns in the row.
SQL CHECK Constraint on CREATE TABLE
The following SQL creates a CHECK constraint on the “P_Id” column when the “Persons” table is created. The CHECK constraint specifies that the column “P_Id” must only include integers greater than 0.
My SQL:
CREATE TABLE Persons ( P_Id int NOT NULL, LastName varchar(255) NOT NULL, FirstName varchar(255), Address varchar(255), City varchar(255), CHECK (P_Id>0) )
SQL Server / Oracle / MS Access:
CREATE TABLE Persons ( P_Id int NOT NULL CHECK (P_Id>0), LastName varchar(255) NOT NULL, FirstName varchar(255), Address varchar(255), City varchar(255) )
To allow naming of a CHECK constraint, and for defining a CHECK constraint on multiple columns, use the following SQL syntax:
MySQL / SQL Server / Oracle / MS Access:
CREATE TABLE Persons ( P_Id int NOT NULL, LastName varchar(255) NOT NULL, FirstName varchar(255), Address varchar(255), City varchar(255), CONSTRAINT chk_Person CHECK (P_Id>0 AND City=’Sandnes’) )
SQL CHECK Constraint on ALTER TABLE
To create a CHECK constraint on the “P_Id” column when the table is already created, use the following SQL:
MySQL / SQL Server / Oracle / MS Access:
ALTER TABLE Persons ADD CHECK (P_Id>0)
To allow naming of a CHECK constraint, and for defining a CHECK constraint on multiple columns, use the following SQL syntax:
MySQL / SQL Server / Oracle / MS Access:
ALTER TABLE Persons ADD CONSTRAINT chk_Person CHECK (P_Id>0 AND City=’Sandnes’)
To DROP a CHECK Constraint
To drop a CHECK constraint, use the following SQL:
SQL Server / Oracle / MS Access:
ALTER TABLE Persons DROP CONSTRAINT chk_Person
Incoming search terms for the article:
find schema of oracle database, dropping check constraint in mysql, how to drop check constraint in mysql, mysql drop check constraint, drop check constraint in mysql, drop check constraint mysql, oracle check constraint on two columns, SQL constraint check, sql constraint column values check mysql, mysql check constraint, access 2010 check constraint, access 2010 constrain check, access 2010 sql add constraint check, mq sql varchar constraints check, mysql check constraint int range between, microsoft access 2010 create check constraint, mysql check constraint on multiple columns, mysql check constraint syntax, mysql check constraints syntax, mysql constraint check, make check constraint on access, mysql drop check constraints, mysql int range constraint, not able to use check constraint in ms acess, microsoft access check constraints sql, mysql add constraint check, microsoft access sql check constraint, ms access 2010 check constraint, ms access 2010 defining check constraints in sql, ms access check constraint, ms access sql check constraint, ms access sql check CONSTRAINTS table, microsoft access constraint sql syntax, ms sql check constraint on multiple columns, microsoft access constraint check, msaccess 2010 check constraint, mssql check constraint int range, mysql - drop check constraint, oracle alter table add check, oracle alter table add constraints multiple, sql check_constraint, visual studio 2010 drop check constraints, sql constraints integer value range mysql, sql server check constraint, sql server check constraint multiple columns, sql server check constraint to only allow certain varchar values, syntax check constraint 1 or 0 in sql, syntax check constraint sql server, syntax for checking multiple constraints in mysql, syntax for the check constraint in my sql, syntax for value constraints in ms access sql, to allow naming of a check constraint and for defining a check constraint on multiple columns use the following sql syntax:, using check constraint for multiple columns in ms access, using check constraint in ms access, sql check range, sql check in specific values, sql check constraint varchar, oracle check constraints in ( syntax, oracle drop multiple check constraints, oracle sql add constraint check in 0 1, oracle sql check constraint syntax, oracle sql check range constraint, oracle sql constraint not, range check varchar oracle, range constraint sql, sql access2010 constraint, sql add check multiple columns, sql add comment to check constraint, Sql Add greater than 0 constraint, sql check constraint, sql check constraint for adding specific cities, using check constraint mysql, a check constraint in VS 2010, add column constraint in access for a range?, ADD CONSTRAINT access how to, alter check constraint in mysql, alter table ADD CHECK ( access, alter table add check constraint in mysql, alter table add constraints mysql, alter table check constraint microsoft access 2010, alter table check vs alter table add check, check constraint access 2010, check constraint for city in sql, check constraint for multiple words in sql server, check constraint in access 2010, check constraint in ms access, check constraint in mysql example, access sql server check constraint, access sql DROP CONSTRAINT multiple columns, access 2010 column constraint, access 2010 create a check constraint, access 2010 create table check constraint, access 2010 drop constraint, access 2010 sql alter table check, access 2010 sql constraints, access 2010 sql syntax check, access check constraint, access check constraint sql, access constraints sql, ACCESS CREATE CONSTRAINT
