Shulou(Shulou.com)05/31 Report--

This article mainly shows you "how to check which SP called the corresponding table in the database", the content is easy to understand, well-organized, hope to help you solve your doubts, let the editor lead you to study and learn this article "how to check which SP called the corresponding table in the database".

1. Query which stored procedures (hereinafter referred to as SP) are used by a table:

Select distinct object_name (id) from syscomments where id in

(select object_id from sys.objects where type ='P') and text like'%TableName%'

two。 Find out which procedures have updated the table:

Select distinct object_name (id) from syscomments where id in

(select object_id from sys.objects where type ='P') and text like'%update tablename%'

3. Query all SP in the current database:

Select name as stored procedure from sysobjects where type ='P'

The above is all the contents of the article "how to check which SP called the corresponding table in the database". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.