ExamVeda
Login
Home
This question belongs to MySQL MySQL Miscellaneous
MySQL Miscellaneous
?

To see the table structure, which of the following SQL commands is issued?

Answer & Solution
Correct Answer: Option A
This question asks about how to see the structure of a table in MySQL. The structure of a table refers to its columns, their data types, and other defining characteristics.
Here's a breakdown of the options:
Option A: DESCRIBE tbl_name
This is the correct answer. The DESCRIBE command in MySQL is specifically designed to show the table structure. It lists all the columns, their data types, and other information about the table's definition.
Option B: VIEW tbl_name
VIEW is a virtual table based on a query. It doesn't directly show the structure of the table.
Option C: SELECT TABLE tbl_name
This syntax is incorrect. The SELECT statement is used to retrieve data from a table.
Option D: SELECT tbl_name
This is also incorrect. The SELECT statement is used to retrieve data from a table.
Therefore, the correct answer is Option A: DESCRIBE tbl_name.
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.