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:
Post a Comment