|
分類:[VB.NET]
Oracle 特化という事でよいのなら…。
SELECT
A.OWNER,
A.CONSTRAINT_NAME,
A.TABLE_NAME,
B.POSITION,
B.COLUMN_NAME
FROM
USER_CONSTRAINTS A INNER JOIN USER_CONS_COLUMNS B ON
A.OWNER = B.OWNER AND
A.CONSTRAINT_NAME = B.CONSTRAINT_NAME
WHERE
A.CONSTRAINT_TYPE = 'P' AND
A.TABLE_NAME = 'テーブル名'
ORDER BY
A.OWNER,
A.TABLE_NAME,
B.POSITION
|