View Single Post
  #4 (permalink)  
Old 03-11-2007, 05:11 PM
meera
 
Posts: n/a
Default MySQL answer. Re: How to get table structure via SQL?

[sql]
describe ;
[/sql]
or
[sql]
select column_name,column_type,is_nullable,column_key,col umn_default,extra from information_schema.columns where
table_schema='' and table_name=''
[/sql]
Reply With Quote