Displaying the Table Structure

Displaying the Table Structure

We can display the structure of a table by using the DESCRIBE command. The command displays the column names and the data types, and it shows you whether a column must contain data (that is, whether the column has a NOT NULL constraint).

In the syntax, the table name is the name of any existing table, view, or synonym that is accessible to the user. The Keyword DESC can be also used for the same purpose. 

Ex.

DESC employees;

DESCRIBE employees;