Examveda

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

A. DESCRIBE tbl_name

B. VIEW tbl_name

C. SELECT TABLE tbl_name

D. SELECT tbl_name

Answer: Option A

Solution (By Examveda Team)

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.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous