How to update primary key

by

You shouldn’t really do this but insert in a new record instead and update it that way.
But, if you really need to, you can do the following:

  • Disable enforcing FK constraints temporarily (e.g. ALTER TABLE foo WITH NOCHECK CONSTRAINT ALL)
  • Then update your PK
  • Then update your FKs to match the PK change
  • Finally enable back enforcing FK constraints

More Related Contents:

  1. If condition in SQL Server 2008
  2. Comma separated results in SQL
  3. Using merge..output to get mapping between source.id and target.id
  4. Understanding PIVOT function in T-SQL
  5. SQL Server, How to set auto increment after creating a table without data loss?
  6. How can I truncate a datetime in SQL Server?
  7. Which are more performant, CTE or temporary tables?
  8. Using RegEx in SQL Server
  9. Errors: “INSERT EXEC statement cannot be nested.” and “Cannot use the ROLLBACK statement within an INSERT-EXEC statement.” How to solve this?
  10. Import Excel spreadsheet columns into SQL Server database
  11. When/Why to use Cascading in SQL Server?
  12. SqlServer: Login failed for user
  13. SQL Server 2008 Empty String vs. Space
  14. How to set a default value for an existing column
  15. How to drop column with constraint?
  16. SQL Server: combining multiple rows into one row
  17. SQL Server Query: Fast with Literal but Slow with Variable
  18. How do I find a stored procedure containing ?
  19. SQL Server GUID sort algorithm. Why?
  20. How to create the linked server for SQL Server 2008 where we have the database from 2000 and 2005
  21. Sort Bullets in Database
  22. Unable to login to SQL Server + SQL Server Authentication + Error: 18456
  23. What’s the best way to store co-ordinates (longitude/latitude, from Google Maps) in SQL Server?
  24. Instead of trigger in SQL Server loses SCOPE_IDENTITY?
  25. How to wait for 2 seconds?
  26. Can I have a foreign key referencing a column in a view in SQL Server?
  27. Find broken objects in SQL Server
  28. Error converting data types when importing from Excel to SQL Server 2008
  29. CHECKSUM and CHECKSUM_AGG: What’s the algorithm?
  30. Populate Dataset With Table Names From Stored Procedure

Leave a Comment