More than 5 years have passed since last update.

PostgreSQL 外部キー一覧の取得

Last updated at 2013-10-17Posted at 2013-10-17

information_schema.table_constraints を参照する.

SELECT table_name, constraint_name
FROM information_schema.table_constraints
WHERE table_schema = 'public'
    AND constraint_type = 'FOREIGN KEY';

外部キー制約を削除するには…

ALTER TABLE <<table_name>>
DROP CONSTRAINT IF EXISTS <<constraint_name>>;