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

Joined
Oct 24, 2013
Messages
47
Reaction score
0
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.
 

Attachments

  • Database.png
    Database.png
    297.1 KB · Views: 4
Joined
Jun 21, 2023
Messages
6
Reaction score
0
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,813
Messages
2,569,696
Members
45,481
Latest member
Arnulfo32P

Latest Threads

Top