PLSQL - Checking if a table/sequence/trigger exists

[fatcodeguy]

Hi,

How can I check whether a table/sequence/trigger (or really, any database object) exists in a database?

Thanks!!

 

[Custom24]

Check out the all_objects view.

Mark

 

[fatcodeguy]

Thanks!

 

[macswell]

Select * from all_triggers [ where owner = '<name>'];