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 columns(4 new columns) in the same table and every section where FPPaymentID is used. Please see pic for more info.enter image description here

I am looking for an Excel-like find feature.

Karim Ali
  • 2,243
  • 6
  • 23
  • 31
  • Have you consulted the system objects? Specifically the `columns` and `tables` system objects? – Thom A Jun 20 '23 at 15:19
  • Also, what is a "field" in this context? Tables don't have fields, and you use "column" (correctly) prior in the post implying that a "field" is something different. – Thom A Jun 20 '23 at 15:20
  • I mean columns. – Karim Ali Jun 20 '23 at 15:25
  • I am not an SQL person. Can someone please tell me how to use system objects? – Karim Ali Jun 20 '23 at 15:43
  • 1
    What were wrong with the answers in [Find all tables containing column with specified name - MS SQL Server](https://stackoverflow.com/questions/4849652/find-all-tables-containing-column-with-specified-name-ms-sql-server)? – Thom A Jun 20 '23 at 15:44
  • Find all tables containing column with specified name - MS SQL Server only gives me the column name in the tables, What about stored procedure, views etc – Karim Ali Jun 20 '23 at 15:50

0 Answers0