Tuesday, October 20, 2009

How to get the table name from one of it's column name?

If you know the column name, but not the table name in a particular data base, then how to get the column name?

select * from sys.all_columns where name like 'ColumnNam%' , can give U the list of matching columns, but how to map that to the corresponding table?

No comments: