Hiiii,is there any sql script to find the all primary keys tables on a particular owner?
thanks
kavitha
Printable View
Hiiii,is there any sql script to find the all primary keys tables on a particular owner?
thanks
kavitha
Code:select
TABLE_NAME, CONSTRAINT_NAME, STATUS
from
DBA_CONSTRAINTS
where
owner = 'ABC' and constraint_type = 'P'
order by
TABLE_NAME desc;