Query to fetch column names
SQL server 2008
Select column_name,*from information_schema.columns where table_name='tblnm' order by ordinal_position
Oracle 11g
Select column_name from all_tab_columns where table_name=upper('tblnm')
Query to fetch table name which use particular column
Select tbname from sysibm.syscolumns where name like '%column_name'
