表の主キーを確認する

Tweet

Pocket

set lines 120
set pages 1000

clear col
ttitle off

col table_name form a30 head “テーブル名”
col constraint_name form a30 head “制約名”
col column_name form a30 head “列名”

SELECT ucc.table_name
,ucc.constraint_name
,ucc.column_name
FROM user_cons_columns ucc
,user_constraints uc
WHERE ucc.constraint_name = uc.constraint_name
AND uc.constraint_type = ‘P’;

clear col
ttitle off