sql1

--１．最初にプライマリキーを削除
SELECT
     'ALTER TABLE '
     + tbls.name
     + ' DROP CONSTRAINT '
     + key_const.name  + ';' AS "プライマリキーを削除"
FROM
    sys.tables AS tbls
        INNER JOIN sys.key_constraints AS key_const ON
            tbls.object_id = key_const.parent_object_id AND
key_const.type = 'PK'
            AND tbls.name like 'TEST_%'