Computer Science
How would you view the structure of table Dept ?
DDL & DML
2 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
1 Like
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 ?
UPDATE EMPL ;