how to show the structure of table in sql
snippet in sql

how to show the structure of table in sql

user7895

DESC one
  OR
DESCRIBE one

how to show the structure of table in sql

user2504

Output:
Name      Null       Type
ID       Not Null    INT
NAME                CHAR(25)
CITY                VARCHAR2(25)