Welcome to Sign in | Help

Re: disable/enable foreign keys constraints

  •  03-25-2009, 5:58 PM

    Re: disable/enable foreign keys constraints

    Nu uita ca atunci când termini să-i dai:

    exec sp_MSforeachtable 'ALTER TABLE ? WITH CHECK CHECK CONSTRAINT ALL' 

    Clauza WITH CHECK este utilă pentru a face constraint-urile să fie din nou "trusted".

    Răzvan

View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems