Thanks for your reply. Will this work for if i have to get values from tables present in different databases. I have a source1 and source 2 database and I have to get details with respect to individual databases.
quote:Originally posted by Peso
select * from information_schema.columns where table_name = '<your table name here>'