Vidyalelo
MySQL · Q854

MySQL

Programming · MySQL · question 854

Q854

To see the table structure which command is issued?

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

Answer: Option D

Solution

Answer: Option D
Solution:
This question asks you about how to see the structure of a table in MySQL. The structure refers to the columns, their data types, and other details about how the table is organized.

Here are the options:
Option A: VIEW tbl_name;
This is incorrect. VIEW is used to create a virtual table based on an existing table, not for viewing the structure.
Option B: SELECT TABLE tbl_name;
This is also incorrect. SELECT is used for retrieving data from a table, not for viewing its structure.
Option C: SELECT tbl_name;
This is incorrect. SELECT is used for retrieving data from a table, not for viewing its structure.
Option D: DESCRIBE tbl_name;
This is the correct answer! DESCRIBE is the command used in MySQL to display the structure of a table. It shows you the column names, their data types, and other properties.
So the answer to this question is Option D: DESCRIBE tbl_name;