CBSE Class 12 Computer Science Question 14 of 79

Table Creation and Data Manipulation Commands — Question 8

Back to all questions
8
Question

Question 8

How would you view the structure of table Dept ?

Answer

To view the structure of a table in SQL, we use DESC[RIBE] command of MySQL * Plus. The syntax of this command is as follows : DESC[RIBE] <tablename> ;.

For example, the command to view the structure of table Dept is DESCRIBE Dept ; or DESC Dept ;.