structure of a table in sql code example
Example 1: table structure in sql
select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='<Table Name>'
Example 2: table structure in sql
DESCRIBE one;
OR
DESC one;
select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='<Table Name>'
DESCRIBE one;
OR
DESC one;