用户USER下无主键表:
SELECT b.TABLE_NAME FROM all_tables b WHERE b.OWNER=‘USER’ and b.TABLE_NAME not in
(select c.table_name from user_cons_columns c,user_constraints a where c.constraint_name=a.constraint_name and a.constraint_type=‘P’ and c.owner = ‘USER’);
数据库筛选无主键表
最新推荐文章于 2024-04-09 09:28:12 发布