Which SQL command is commonly used to display the structure of a table in MySQL?

Options

  • A. DESCRIBE
  • B. DELETE
  • C. INSERT
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

A. DESCRIBE

Detailed Explanation

  • DESCRIBE table_name: Displays information about the columns of a table.
  • It shows column names, data types, NULL permissions, keys and default values.
  • It is commonly used to inspect table metadata in MySQL.