Querying method names for each type in the database

Select name from sysobjects where xtype= ' TR '--all triggers
Select name from sysobjects where xtype= ' P '--all stored procedures
Select name from sysobjects where xtype= ' V '--all views
Select name from sysobjects where xtype= ' U '--All tables

The above is SQL Server usage

Select object_name from user_objects Where object_type= ' TRIGGER ';  --All triggers
Select object_name from user_objects Where object_type= ' PROCEDURE ';  --All stored procedures
Select object_name from user_objects Where object_type= ' VIEW ';  --All views
Select object_name from user_objects Where object_type= ' TABLE '; --All Tables

The above is Oracle usage

Querying method names for each type in the database