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'

This page was last updated on May 01, 2006 04:28 PM.