Find the table name all the stored Procedures are using

by Deepak Dhakal 4. August 2009 10:48

So you want to find the table name ' A' being used in all the procedures.

 

Use this query

SELECT ROUTINE_NAME, ROUTINE_DEFINITION

    FROM INFORMATION_SCHEMA.ROUTINES

    WHERE ROUTINE_DEFINITION LIKE '%license%'

    AND ROUTINE_TYPE='PROCEDURE'

 

where '%license%'  is the Table name to be found .. 

 

Tags:

SQL

Powered by BlogEngine.NET 1.5.0.7 - Old School Theme by n3o Web Designers