search

microsoft / sql-server-samples

Azure Data SQL Samples - Official Microsoft GitHub Repository containing code samples for SQL Server, Azure SQL, Azure Synapse, and Azure SQL Edge
Other
10.09k stars 8.9k forks source link

Add new sample that describes an option to regenerate IDENTITY column values #1325

Closed segovoni closed 2 months ago

segovoni commented 3 months ago

This sample describes an option to regenerate IDENTITY column values in SQL Server and Azure SQL, ensuring referential integrity and preserving related objects like constraints, indexes, and triggers. This process prevents data overflow errors and maintains data consistency without renaming or losing linked objects.

uc-msft commented 2 months ago

Please publish this sample as a blog post. This does not belong in the SQL Server Samples.