SQL Server Find redundant stored procedures which have the same body

2uluyalo 于 2023-10-15 发布在其他

关注(0)|答案(1)|浏览(87)

I have a database and there are some stored procedures with different names but the same body. How can I identify them dynamically using a T-SQL statement?

I cannot use definition column of information_schema.routines tables because it has create procedure name in it. Hence without that how can I check dynamically redundant procedures.

I tried using different joins and routines tables but couldn't find the right solution.

sql-server

来源：https://stackoverflow.com/questions/76947780/find-redundant-stored-procedures-which-have-the-same-body

1条答案

按热度按时间

js5cn81o1#

I know your question indicated you are looking to do this inside of SQL, but alternatively you could look at using something like SQL Search to find these duplicates based on key words inside your stored procedure body.

On object types of procedures and a matching based on text.