Sql Server数据库用SQL语句查询方法如下：

select name from sysobjects where xtype='TR' --所有触发器

select name from sysobjects where xtype='P' --所有存储过程select name from sysobjects where xtype='V' --所有视图select name from sysobjects where xtype='U' --所有表

Oracle数据库用SQL语句查询方法如下：Select object_name From user_objects Whereobject_type='TRIGGER';  --所有触发器Select object_name From user_objects Whereobject_type='PROCEDURE';  --所有存储过程Select object_name From user_objects Whereobject_type='VIEW';  --所有视图Select object_name From user_objects Where object_type='TABLE';--所有表