I can look in information_schema.routines to see all the SPs. But I need a report like the foll:
TableName1, <List Of all the SPs that reference table1, separated by delimiter>
TableName2, <List Of all the SPs that reference table2, separated by delimiter>
for all the tables in the DB.
can you please suggest a way to accomplish this?