As a user i want to disable Foreign keys and other constraints in order to insert data without caring about constraints

dknight52 / sql-server-data-producer

Automatically exported from code.google.com/p/sql-server-data-producer

0 stars 0 forks source link

As a user i want to disable Foreign keys and other constraints in order to insert data without caring about constraints #102

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago

If there is any foreign keys required for a table then there should be an 
option available to disable them.

Original issue reported on code.google.com by a03pe...@gmail.com on 4 Dec 2012 at 10:33

GoogleCodeExporter commented 9 years ago

Original comment by a03pe...@gmail.com on 4 Dec 2012 at 1:17

Changed title: Foreign keys and other constraints should be possible to be disabled

GoogleCodeExporter commented 9 years ago

Original comment by a03pe...@gmail.com on 10 Dec 2012 at 10:01

Changed title: As a user i want to disable Foreign keys and other constraints in order to insert data without caring about constraints

GoogleCodeExporter commented 9 years ago

Original comment by a03pe...@gmail.com on 20 Dec 2012 at 11:23

Changed state: New

GoogleCodeExporter commented 9 years ago

--disable all constraints for the Sales.SalesOrderHeader table 
ALTER TABLE Sales.SalesOrderHeader NOCHECK CONSTRAINT ALL  

--do something  --enable all constraints for the Sales.SalesOrderHeader table 
ALTER TABLE Sales.SalesOrderHeader CHECK CONSTRAINT ALL

Original comment by a03pe...@gmail.com on 26 Feb 2013 at 1:55