--https://www.cnblogs.com/ljcbest/archive/2010/09/02/1816346.html
https://www.cnblogs.com/lcword/p/9562581.html
select t.table_name from user_tables t order by table_name;--所有表名
select count(1) from user_tables t order by table_name; --所有表名计数
select t.column_name from user_col_comments t;--所有字段名
select * from user_col_comments t order by t.table_name ,t.column_name ;--所有表名 字段名
select count(1) from user_col_comments t order by t.table_name ; --所有字段计数
select 'drop table ' ||table_name ||';' from user_tables; --删除所有表
select 'alter table '||table_name||' disable constraint '||constraint_name||';' from user_constraints where constraint_type='R';
--查询所有外键约束
-- enable constraint
-- drop constraint
select count(1) from user_constraints;--约束计数
select * from user_constraints order by table_name;--查询所有约束
select * from user_constraints where status = 'DISABLED' order by table_name;--查询所有停用约束
alter table table_name drop constraint constraint_name;--删除约束
alter table GEFS_XETC_RECORD disable constraint GEFS_XETC_RECORD_PK; --启用停用一条 表/名
select 'alter table '|| table_name|| ' drop constraint ' || constraint_name || '; ' from user_constraints;--删除所有约束
select 'alter table '|| table_name|| ' disable constraint ' || constraint_name || '; ' from user_constraints;--停用所有约束
select 'alter table '|| table_name|| ' enable constraint ' || constraint_name || '; ' from user_constraints;--启用所有约束
查询所有表名:
select t.table_name from user_tables t;
查询所有字段名:
select t.column_name from user_col_comments t;
查询指定表的所有字段名:
select t.column_name from user_col_comments t where t.table_name = 'BIZ_DICT_XB';
查询指定表的所有字段名和字段说明:
select t.column_name, t.column_name from user_col_comments t where t.table_name = 'BIZ_DICT_XB';
查询所有表的表名和表说明:
select t.table_name,f.comments from user_tables t inner join user_tab_comments f on t.table_name = f.table_name;
查询模糊表名的表名和表说明:
select t.table_name from user_tables t where t.table_name like 'BIZ_DICT%';
select t.table_name,f.comments from user_tables t inner join user_tab_comments f on t.table_name = f.table_name where t.table_name like 'BIZ_DICT%';
--查询表的数据条数、表名、中文表名
select a.num_rows, a.TABLE_NAME, b.COMMENTS
from user_tables a, user_tab_comments b
WHERE a.TABLE_NAME = b.TABLE_NAME
order by TABLE_NAME;