Computer Science

How would you view the structure of table Dept ?

DDL & DML

3 Likes

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 ;.

Answered By

3 Likes

Computer Science

How would you view the structure of table Dept ?

DDL & DML

Answer

Related Questions

When a column's value is skipped in an INSERT command, which value is inserted in the database ?

Can a column defined with NOT NULL constraint, be skipped in an INSERT command ?

Table Empl has same structure as that of table EMPL. Write a query statement to insert data from table NewEmpl into EMPL where salary and comm is more than Rs. 4000.

What is the error in following statement ?