Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
After a data engineer adds a CHECK constraint to the 'sales' table with the command ALTER TABLE sales ADD CONSTRAINT valid_date CHECK (item_date >= ‘2023-01-01‘);, which command should they use to verify the constraint's successful addition?
ALTER TABLE sales ADD CONSTRAINT valid_date CHECK (item_date >= ‘2023-01-01‘);
A
SHOW TBLPROPERTIES sales
B
DESCRIBE TABLE sales
C
DESCRIBE EXTENDED sales
D
SHOW CONSTRAINTS sales
E
SHOW CONSTRAINT valid_date
