how to sql for column names

mdwu · Sep 9, 2004

What's the sql query to find the column names of table. thanks.

dbomrrsm · Sep 10, 2004

Code:

select * from information_schema.columns
where TABLE_CATALOG = 'YOUR_DATABASE'

[blue]DBomrrsm[/blue] [bandito]

dbomrrsm · Sep 10, 2004

Sorry for a specific table:

Code:

SELECT * FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_CATALOG = 'YOUR_DATABASE'
AND TABLE_NAME = 'YOUR_TABLE_NAME'

[blue]DBomrrsm[/blue] [bandito]

mdwu · Sep 10, 2004

thanks..awesome.

dbomrrsm · Sep 10, 2004

glad to be of help

[bandito]

[blue]DBomrrsm[/blue] [bandito]