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.
OOps! You are currently offline.