Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
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?
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;_