Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
find stored procedures referencing table x?
- Thread starter snippy
- Start date
Hi,
A possible solution for your requirement would look similar to the following SQL:
select procname
from sysprocedures
where procid in
(
select procid
from sysprocbody
where datakey='T' and data matches '* your_table_name *'
) ;
Regards,
Shriyan
A possible solution for your requirement would look similar to the following SQL:
select procname
from sysprocedures
where procid in
(
select procid
from sysprocbody
where datakey='T' and data matches '* your_table_name *'
) ;
Regards,
Shriyan
- Status
Similar threads
- Locked
- Question
- Locked
- Question