关于触发器反面的基本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' --所有表以上为SqlServer用法Select object_name From user_objects Where object_type='TRIGGER'; --所有触发器Select object_name From user_objects Where object_type='PROCEDURE'; --所有存储过程Select object_name From user_objects Where object_type='VIEW'; --所有视图Select object_name From user_objects Where object_type='TABLE'; --所有表以上为Oracle用法

转载于:https://www.cnblogs.com/zhouchunDIY/p/7777336.html