Concepts and Architecture Question:
Explain what are the Limitations of a CHECK Constraint?
Answer:
A check constraint allows you to specify a condition on each row in a table. Note: A check constraint can NOT be defined on a VIEW. The check constraint defined on a table must refer to only columns in that table. It can not refer to columns in other tables. A check constraint can NOT include a SUBQUERY. A check constraint can be defined in either a CREATE TABLE statement or an ALTER TABLE statement.
| Previous Question | Next Question |
| Tell me what is difference between UNIQUE constraint and PRIMARY KEY constraint? | Explain what is a Synonym? |