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?
Reddy

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
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Thanks. I got it. Reddy

]]>