Monday, May 19, 2014

Query to fetch column names

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'