1) To change all the constraints names for all tables would be quite a large job, and is hard to automate since you may need to name the constraints appropriately. You can use the sp_rename system stored prcoedure to do the renaming. To get a list of constraints in your database you could use the sysconstraints system table (SQL Server ...