Question

what are table constraints? what are column constants? how are these two different?

this question is from SQL chapter

Answer 1

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.

Answer 2

Explanation:

Plz mark me brainliest and follow