Eradicating Dependencies of Tables

Question

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

BBaggins Grasshopper Points: 11 More actions · Answer 1

This will generate a script to drop all FK's:

SELECT 'ALTER TABLE ' +

QUOTENAME( c.TABLE_NAME ) +

' NOCHECK CONSTRAINT ' +

QUOTENAME( c.CONSTRAINT_NAME ) AS ALTER_SCRIPT

FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS c

WHERE CONSTRAINT_TYPE = 'FOREIGN KEY'

You don't need a parachute to skydive.

You only need a parachute to skydive twice.

You don't need a parachute to skydive.
You only need a parachute to skydive twice.