To find out which table has the column name in DB - MS SQL

To find which table has the column name like 'test' in Database MS SQL


select * from sys.all_columns C 
join sys.tables T on C.object_id = T.object_id 
where C.name like '%test%' 




Posted by Manivannan at 4:26 AM

No comments:

Post a Comment

Keep ur coding aside.. Relax for some time..


Poodwaddle.com