Hiiii,is there any sql script to find the all primary keys tables on a particular owner? thanks kavitha
kavitha
Code: select TABLE_NAME, CONSTRAINT_NAME, STATUS from DBA_CONSTRAINTS where owner = 'ABC' and constraint_type = 'P' order by TABLE_NAME desc;
select TABLE_NAME, CONSTRAINT_NAME, STATUS from DBA_CONSTRAINTS where owner = 'ABC' and constraint_type = 'P' order by TABLE_NAME desc;
Oracle Certified Master Oracle Certified Professional 6i,8i,9i,10g,11g,12c email: ocp_9i@yahoo.com
Forum Rules