--查询所有表
SELECT *
FROM SYS.ALL_OBJECTS O
WHERE O.OBJECT_TYPE = 'TABLE'
AND O.OWNER = '数据库名字';
--查询所有视图
SELECT *
FROM SYS.ALL_OBJECTS O
WHERE O.OBJECT_TYPE = 'VIEW'
AND O.OWNER = '数据库名字';
--查询所有索引
SELECT *
FROM SYS.ALL_OBJECTS O
WHERE O.OBJECT_TYPE = 'INDEX'
AND O.OWNER = '数据库名字';
--查询所有触发器
SELECT *
FROM SYS.ALL_OBJECTS O
WHERE O.OBJECT_TYPE = 'TRIGGER'
AND O.OWNER = '数据库名字';
--查询所有存储过程
SELECT *
FROM SYS.ALL_OBJECTS O
WHERE O.OBJECT_TYPE = 'PROCEDURE'
AND O.OWNER = '数据库名字';
--其中OBJECT_TYPE还包括其他的一些数据库对象。
--查看OBJECT_TYPE的值
SELECT DISTINCT OBJECT_TYPE
FROM SYS.ALL_OBJECTS O