Monthly Archives: January 2020

Data Import or Update Operations on tables with constraints

If table has constraints, SQL’s data import wizard will throw error while importing data from another table or from test database to prod database. In these cases, it is possible to disable constraints for particular tables. List of constraints can be queried with the script given below. SELECT OBJECT_NAME(constraint_object_id) ‘Constraint… Read more »