SQL Server Performance Forum – Threads Archive
Search for ColumnsHi All, Is there any fast way to search for a column(s) in SQL Server?
Search for column means what ? Are u trying to search for
a column in other tables where it might be present ..if so
then you can use either syscolumns and information_schema.columns.
If you want to search for a column being referred in SP then
u shud use syscomments … Srini
Searcing for a column or its value?
If you mean column then Select table_Name, column_name from information_Schema.columns where column_name=’ColName’ Madhivanan Failing to plan is Planning to fail
Please post thread in relevant forums. Take help from thishttp://vyaskn.tripod.com/sql_server_search_and_replace.htm link to search and replace, if you need. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
Thanks. I got it. Reddy