RE: I'd like to know SQL query for table description.

[Jay Blanchard]

[snip]
and then, result is table description.

ex) 
dbms_type,table_name,column_name,data_type,data_size,constraint_type

What SQL query can I get this information ?
[/snip]

DESCRIBE `tablename`;