1. Introduction to the Emp-dept case study: Step 6

Demo

To view the definition of a table.

The describe command will return the list of fields in the table. For example, to view the structure of the Employee table (emp):

SQL

DESCRIBE emp;

Output

Field Type Null Key Default Extra
empno int(4) NO PRI
ename varchar(50) NO
job varchar(50) NO
mgr int(4) YES
hiredate date YES
sal decimal(10,2) YES
comm decimal(10,2) YES
deptno int(2) NO

Discussion

The table shows:

Progress

Proceed to Next step