What is check constraint?
Answers were Sorted based on User's Feedback
Answer / rajeev
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.
Is This Answer Correct ? | 2 Yes | 1 No |
example of check constraint
CREATE TABLE Customer_Details(
Cust_ID Number(5) CONSTRAINT Nnull1 NOT NULL
CONSTRAINT Ccheck1 CHECK( Cust_ID BETWEEN 101 AND 105),
Cust_Last_Name VarChar2(20) CONSTRAINT Nnull2 NOT NULL,
Cust_Mid_Name VarChar2(4),
Cust_First_Name VarChar2(20),
Account_No Number(5) CONSTRAINT Pkey1 PRIMARY KEY,
Account_Type VarChar2(10) CONSTRAINT Nnull3 NOT NULL,
Bank_Branch VarChar2(25) CONSTRAINT Nnull4 NOT NULL,
Cust_Email VarChar2(30)
);
Is This Answer Correct ? | 1 Yes | 0 No |
Can python connect to mysql?
What is triggers?
how we can use more then one primary key in Single Table
Can you tell the difference between ereg_replace() and eregi_replace()?
Which is faster mysql or mongodb?
how to dump all databases for backup. Backup file is sql commands to recreate all db's.
What is blob datatype in mysql?
Transactions are used to treat sets of SQL statements atomically. State Whether True or False?
What is mysql port?
Why to use char instead of varchar in the database?
How do you restart mysql?
What is the difference between truncate and delete in mysql?