The command used to see the fields of the table along with their datatypes in…
2013
The command used to see the fields of the table along with their datatypes in SQL is
- A.
Select fields from dual where table = "MANAGER";
- B.
Select field_names, datatype from dual where table_name = "MANAGER";
- C.
Desc MANAGER;
- D.
Select description from dual where table_name = "MANAGER";
Attempted by 1822 students.
Show answer & explanation
Correct answer: C
Answer: DESCRIBE (or DESC) command is used to describe the structure of a table. It shows the fields along with their datatypes, nullability, and other attributes. Syntax: DESCRIBE table_name;
A video solution is available for this question — log in and enroll to watch it.