Sql query to view table structure in oracle

Prerequisite:SQL Create Clause

As the name suggests, DESCRIBE is used to describe something. Since in a database, we have tables, that’s why do we use DESCRIBE or DESC(both are the same) commands to describe the structure of a table.

 Syntax:

DESCRIBE one;

  OR

DESC one;

Note: We can use either DESCRIBE or DESC(both are Case Insensitive).

Suppose our table whose name is one has 4 columns named id, name, email, and age and all are of can contain null values. 

Query:

CREATE TABLE users ( id INT PRIMARY KEY, name VARCHAR(50), email VARCHAR(100), age INT ); DESC users;

Output:

Here, above on using DESC or either DESCRIBE we are able to see the structure of a table but not on the console tab, the structure of the table is shown in the describe tab of the Database System Software.

So desc or describe command shows the structure of the table which include the name of the column, the data type of the column and the nullability which means, that column can contain null values

sql display table structure

sql get table structure query