Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 21 of 79

MySQL SQL Revision Tour — Question 14

Back to all questions
14
Question

Question 11

What are table constraints ? What are column constraints ? How are these two different ?

Answer

Table constraints are rules or conditions applied to an entire table in a database. They are defined when creating or altering a table's schema.

Column constraints are rules or conditions applied to individual columns within a database table. They are specified at the column level when creating or altering a table's schema.

The difference between the two is that column constraints apply only to individual columns, whereas table constraints apply to groups of one or more columns.