Search for Columns | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Search for Columns

Hi 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 this 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