How SQL Server quickly finds all stored procedures that use a field

When a system uses a lot of tables, and there are a lot of stored procedures, when a table in the database deleted a field, then the corresponding stored procedures need to be changed, but we do not know which stored procedures used the field, then what should we do? We can find stored procedures that use the field from one previous document, but this is much more efficient and error-prone, and we can use the following method to find all stored procedures that use a field. The following function: [SQL] GO SELECT obj. Name stored procedure name, SC. The text stored procedure contents from the syscomments sc INNER JOIN sysobjects obj on SC. Id = Obj.id WHERE SC. TEXT like '% ' + ' field name ' + '% ' and TYPE = ' P ' GO

How SQL Server quickly finds all stored procedures that use a field