Home » SQL & PL/SQL » SQL & PL/SQL » how do i get a list of all triggers,procedures etc associated with a table
how do i get a list of all triggers,procedures etc associated with a table [message #19128] Fri, 01 March 2002 06:20 Go to next message
ksr
Messages: 112
Registered: January 2002
Senior Member
Hi,
what is the select statement which will list all the triggers,procedures,packages and functions which use this table(the table which i want)

any help is appreciated
Re: how do i get a list of all triggers,procedures etc associated with a table [message #19131 is a reply to message #19128] Fri, 01 March 2002 07:53 Go to previous messageGo to next message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
select distinct owner, name, type 
  from all_dependencies
 where referenced_owner = :owner 
   and referenced_name = :name 
   and referenced_type <> 'NON-EXISTENT'
   and referenced_type = 'TABLE'
Re: how do i get a list of all triggers,procedures etc associated with a table [message #19133 is a reply to message #19128] Fri, 01 March 2002 07:58 Go to previous messageGo to next message
ksr
Messages: 112
Registered: January 2002
Senior Member
can you give me an example with a table name called test.
Now i want to get all the triggers,procedures etc associated with the table test.
How do i write the script
Re: how do i get a list of all triggers,procedures etc associated with a table [message #19135 is a reply to message #19128] Fri, 01 March 2002 09:24 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Just drop in the table_name where you see :name ('MYTABLE') and the owner into :owner ('SCHEMANAME').
Previous Topic: Functions
Next Topic: substring help
Goto Forum:
  


Current Time: Fri Mar 29 00:24:48 CDT 2024