Question

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;

The question was posed to me in an online interview.

I need to ask this question from Using Multiple-Statement Execution in chapter MySQL Programs Using C of MySQL

Answer 1

Right answer is (d) DESCRIBE tbl_name;

To elaborate: The ‘DESCRIBE’ command is issued to see the structure of the table ‘tbl_name’. It shows the structure in the format: Field-Type-Null-Key-Default-Extra. The ‘VIEW’ and ‘SELECT’ commands are used to see the contents of the table.