Vidyalelo
MySQL · Q431

MySQL

Programming · MySQL · question 431

Q431

Which clause is used to remove a foreign key constraint?

A.
REMOVE
B.
DELETE
C.
DROP
Answer
D.
EXCLUDE

Answer: Option C

Solution

Answer: Option C
Solution:
This question asks about removing a special rule called a foreign key constraint in a MySQL database.
Think of a foreign key constraint as a rule that says "This data can only exist if it's connected to something else in another table."

Let's look at the options:
A: REMOVE - This is not used for removing foreign key constraints.
B: DELETE - This is used to delete rows of data from a table, not constraints.
C: DROP - This is the correct answer! DROP is used to remove constraints like foreign keys.
D: EXCLUDE - This is not used to remove foreign key constraints.
So, to remove a foreign key constraint, you would use the DROP clause.