what are table constraints? what are column constants? how are these two different?
this question is from SQL chapter
Answers
Answered by
13
A Column constraint has scope only to the column it is defined on. A table constraint can see every column in the table. That is the major difference between the two - that of "scoping". Any column constraint can be expressed at the table level - but the opposite is not true. A column constraint is syntactically more clear - it is OBVIOUS it applies to that single column. It is more meaningful therefore. You would use a column constraint if your constraint is in fact a column constraint. You would use a table constraint otherwise.
Beyond that - they are pretty much the same.
Answered by
2
Explanation:
Plz mark me brainliest and follow
Attachments:
Similar questions