Re-seeding the Identity Value

dbcc checkident ([table to re-seed], reseed, [value to set identity value at])

If you set the value to 0, the next inserted value will be 1

Posted

in

by

djuang1

Tags:

Comments


Amazon S3 Anypoint Monitoring Anypoint Platform Anypoint Studio Apache Kafka API API Management APIs AWS Azure Azure Data Lake Store BigQuery Bot Business Central CI/CD CloudHub Code Connector DataWeave Debugging DropBox Dynamics 365 Facebook File Generative AI Google GPT-3 Grafana Hardware Heroku Java Microsoft MongoDB Mule SDK MuleSoft OAS OpenAI OpenTelemetry Outlook 365 Power BI REST API Salesforce Salesforce Marketing Cloud SAP WSDL