Thread
:
How to get table structure via SQL?
View Single Post
#
4
(
permalink
)
03-11-2007, 05:11 PM
meera
Posts: n/a
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]
meera