Answer-first summary for fast verification
Answer: `DESCRIBE EXTENDED payments`
The correct command to review the comment of the table, along with other custom table properties and columns' comments, is `DESCRIBE EXTENDED`. This command provides a comprehensive overview of the table's metadata, including the comment specified during its creation. Reference: [Databricks SQL Language Manual](https://docs.databricks.com/sql/language-manual/sql-ref-syntax-aux-describe-table.html).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A data engineer has created a new table named 'payments' with a comment stating 'This table contains sensitive information' using the query: CREATE TABLE payments COMMENT 'This table contains sensitive information' AS SELECT * FROM bank_transactions. Which command should the data engineer use to review the comment of the table?
A
SHOW TABLES payments
B
SHOW TBLPROPERTIES payments
C
SHOW COMMENTS payments
D
DESCRIBE TABLE payments
E
DESCRIBE EXTENDED payments
No comments yet.