I've a database in which I would like to do bulk schema changes. The DB does not have FK. I would like to delete following constraints and recreate them later point. In which order I could drop the constraints and in which order I could recreate them?
PK, Default, Unique, NOT NULL, and CHECK, Clustured index, Non clustured index, Triggers
Please assist. Thanks