Oracle 12cでプライマリーキーを取得する
環境
Oracle 12c Windows Server 2012 R2 A5:SQL Mk-2
書式
SELECT COLUMN_NAME FROM USER_CONS_COLUMNS WHERE TABLE_NAME = 'テーブル名' AND CONSTRAINT_NAME IN ( SELECT CONSTRAINT_NAME FROM USER_CONSTRAINTS WHERE TABLE_NAME = 'テーブル名' AND CONSTRAINT_TYPE = 'P')
使用例
SELECT COLUMN_NAME FROM USER_CONS_COLUMNS WHERE TABLE_NAME = 'NEWS_MAST' AND CONSTRAINT_NAME IN ( SELECT CONSTRAINT_NAME FROM USER_CONSTRAINTS WHERE TABLE_NAME = 'NEWS_MAST' AND CONSTRAINT_TYPE = 'P' )
実行結果
COLUMN_NAME TYPE ID