查询数据库里面的所有的表名

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'; --所有表     
Select object_name From user_objects Where object_type='SEQUENCE'; --序列     
    
以上为Oracle用法     

 

 

每天进步 一点点！！

转载于:https://www.cnblogs.com/liences/archive/2011/10/14/2211156.html