Find the table name all the stored Procedures are using

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 ..