This is a dedicated watch page for a single video.
A column named id serves as the PRIMARY KEY for the orders table as well as a FOREIGN KEY to the users table. Which of the following commands can be used to drop the PRIMARY KEY constraint from the orders table while dropping the FOREIGN KEY reference as well?