How can I find occurrences of a column name FPPaymentID in the entire database (e.g table, stored procedure etc) in SSMS?

[asifakhtar]

How can I find occurrences of a column name FPPaymentID in the entire database (e.g table, stored procedure etc) in SQL Server Management Studio (SSMS)?

I have to add a few more fields(4 new fields) in the same table and every section where FPPaymentID is used. Please see pic for more info.

I am looking for an Excel-like find feature.

 

[moongladeflysnow]

you can use the built-in "Find" feature in SSMS to search for the column name. Just hit Ctrl+F (or go to Edit > Find and Replace) and enter "FPPaymentID" in the search box. Make sure to select "Current Document" or "All Open Documents" and hit "Find Next" to locate the occurrences. To add new fields, you'll need to manually update the table and relevant sections where FPPaymentID is used.

 

[Phro0244]

oups