Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
In a database, a column named id is the PRIMARY KEY for the orders table and also a FOREIGN KEY in the users table. Which command correctly removes the PRIMARY KEY constraint from the orders table and simultaneously drops the FOREIGN KEY reference?
id
orders
users
A
ALTER orders DROP PRIMARY KEY CASCADE;
B
ALTER TABLE orders DROP PRIMARY_KEY;
C
ALTER TABLE orders DROP PRIMARY KEY CASCADE;
D
ALTER orders DROP PRIMARY_KEY;
E
ALTER TABLE orders DROP PRIMARY_KEY CASCADE;
