Studio ODIN

�ς�� 2014/06/17

• HTTP/1.1 ���X�V���ꂽ - The Long Wait (2014/06/07)
• Linux�R���e�i�Z�p��Docker���‚��ɐ����łɁA�uDocker 1.0�v�����[�X - SourceForge.JP Magazine (2014/06/10)

PostgreSQL �Őݒ肳��Ă���O���L�[�̈ꗗ���擾����

�����ł��B

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

����Ɏ��̂悤�ɂ���� �������邽�߂� SQL�������ł��܂��B

SELECT 'ALTER TABLE ' || table_schema || '.' || table_name
    || ' DROP CONSTRAINT ' || constraint_name || ';'
FROM information_schema.table_constraints
WHERE constraint_type = 'FOREIGN KEY';