Vidyalelo
MySQL · Q819

MySQL

Programming · MySQL · question 819

Q819

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

A.
DESCRIBE tbl_name
Answer
B.
VIEW tbl_name
C.
SELECT TABLE tbl_name
D.
SELECT tbl_name

Answer: Option A

Solution

Answer: Option A
Solution:
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.