SQL Server Performance Forum – Threads Archive
Drop, truncate rebuild constraintsWhen running an import for a very large table, not needed to be logged, I need to drop the constraints, truncate the table, rebuild the constraints. I dropped the constraints using sp_MSDropConstraint, truncate run fine, but when rebuilding the constraints I got just the ones directly related to the PK in that particular table, but not the FK’s from other tables. What I am doing wrong? Any suggestions? Any input will be appreaciated. Thank you
Generate the script for the constraints including the associate tables for primary & foreign key constraints. Run the DROP script and enable the DTS package to execute and run ADD script to add the constraints. Refer to books online for the topic Constraints –> Precendence for information. HTH Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.