When dropping a constraint,the user is always required to specify the name of the constraint being dropped.

Question

When dropping a constraint,the user is always required to specify the name of the constraint being dropped.​

Quizplus · Accepted Answer

While it's often necessary to specify the name of the constraint to drop it, some database systems allow constraints to be dropped without specifying their names directly, especially if there's a way to implicitly identify the constraint (e.g., dropping a primary key constraint without naming it, if the table has only one).

When Dropping a Constraint,the User Is Always Required to Specify