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 Platform Anypoint Studio Apache Kafka Apache Parquet API API Management APIs AWS Azure Azure Data Lake Store BigQuery Bot CI/CD CloudHub Code Connector DataWeave Facebook File Generative AI Google GPT-3 Heroku Java Maven Messenger Microsoft MongoDB Mule 3.x Mule SDK MuleSoft OAS OpenAI Outlook 365 Power BI RAML REST API Salesforce Salesforce Marketing Cloud SAP Serverless Snowflake SQL WSDL