[DATABASE/SQLSERVER] FK 삭제문 만들기

■ FK 삭제문을 만드는 방법을 보여준다.

 

▶ 예제 코드 (SQL)

SELECT DISTINCT
    'ALTER TABLE ' +
    '[' + OBJECT_NAME(FK.parent_object_id) + ']' +
    'DROP CONSTRAINT ' +
    '[' + FK.name + ']'
FROM       sys.foreign_keys        AS FK
INNER JOIN sys.foreign_key_columns AS FC ON FK.[object_id] = FC.constraint_object_id
WHERE FK.[schema_id] = 1;