18.7k views
0 votes
When dropping a(n) PRIMARY KEY constraint, the name of the column does not need to be included in the ALTER TABLE command. _________________________​

A) True
B) False

User Oskros
by
8.1k points

1 Answer

3 votes

Final answer:

It is true that the column name is not needed when dropping a PRIMARY KEY constraint; you only need to specify the constraint name if it was named during creation.

Step-by-step explanation:

When dropping a PRIMARY KEY constraint, it is True that the name of the column does not need to be included in the ALTER TABLE command. Instead, you must specify the name of the primary key constraint if it was named during its creation. This is because a table can only have one primary key, so the database system knows which constraint you are referring to without needing the column name.

User IneQuation
by
7.4k points