SELECT
*
FROM
user_tables A
WHERE
NOT EXISTS (
SELECT
*
FROM
user_constraints b
WHERE
A .table_name = b.table_name
AND b.constraint_type = 'P'
);
转自:http://bbs.csdn.net/topics/300243837
SELECT
*
FROM
user_tables A
WHERE
NOT EXISTS (
SELECT
*
FROM
user_constraints b
WHERE
A .table_name = b.table_name
AND b.constraint_type = 'P'
);
转自:http://bbs.csdn.net/topics/300243837