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 ..
52f953c9-6538-470c-ba8c-a75fc1e1c0b7|1|5.0
Tags:
SQL