-- 查询表信息
SELECT * FROM user_tables;
SELECT * FROM all_tables;
SELECT * FROM dba_tables; --需要有DBA 权限才可以的
-- 查询当前用户下的所有对象
select * from tab t;
SELECT distinct(tabtype) FROM tab;
-- 查询索引信息
SELECT * FROM user_indexes;
SELECT * FROM user_indexes i where i.table_name like '%BASE%';
SELECT * FROM dba_views;
SELECT * FROM user_ind_columns;
-- 查询视图信息
SELECT * FROM user_views;
-- 查询约束
-- USER_CONSTRAINTS describes all constraint definitions on tables owned by the current user. Its columns are the same as those in "ALL_CONSTRAINTS".
SELECT * FROM user_constraints;
-- ALL_CONSTRAINTS describes constraint definitions on tables accessible to the current user.
SELECT * FROM ALL_CONSTRAINTS;
Oracle查询数据库表信息SQL
最新推荐文章于 2024-06-06 11:52:03 发布