40. Show Table

Show Table


Show Table is used to display the structure of any table  and to generate create table script for that particular table


Example :

show table emp

The output will be,

CREATE

SET TABLE FINANCIAL.emp ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT(
EmpNo SMALLINT FORMAT '999' NOT NULL,
Name VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC,
Salary DECIMAL(8,2),
City VARCHAR(12) CHARACTER SET LATIN NOT CASESPECIFIC,
State VARCHAR(2) CHARACTER SET LATIN NOT CASESPECIFIC,
doj DATE FORMAT 'YYYY-MM-DD')UNIQUE PRIMARY INDEX ( EmpNo );