Hi To find column in a table you posted a code but it is getting results... Here I am posting the code to get column in the table that is also same it is getting results.... but for this i am getting results for one table... but i need all the tables column names in the DB... Plz give me query for that....

SELECT Column_Name 'Column Name',

Data_type 'Data Type', character_maximum_length 'Maxium Length'

FROM information_schema.columns WHERE table_name = 'Table_Name'

:-):-)suresh:-):-)