CodeSolution.org

Your Problems Our Solutions

Skip to content
  • Home
  • All Articles
  • .Net Core
  • SQL Server
  • Interview Questions
CodeSolution.org

How to reset Identity Column in SQL Server.

Share on Facebook Share
Share on TwitterTweet
Share on LinkedIn Share

Query to reset Identity Column

DBCC CHECKIDENT ('Table_Name', RESEED, 0)

Note : Table_Name is the table name in which identity to be reset.

Share on Facebook Share
Share on TwitterTweet
Share on LinkedIn Share

Related posts:

  1. How to find Identity Column in SQL Server?
  2. How to get Referenced Table and Column Name in SQL Server.
  3. What is difference between DELETE & TRUNCATE commands?
  4. How to remove leading zeros from column in table.
This entry was posted in SQL Server and tagged How to reset Identity Column in SQL Server. on July 27, 2015 by Hitesh Kumar.
Avatar

About Hitesh Kumar

A Software Developer with more than 5+ years of rich experience in Software Development in Microsoft Dot Net Technology.

View all posts by Hitesh Kumar →

Post navigation

← How to get Referenced Table and Column Name in SQL Server. Cannot truncate table ‘Table_Name*’ because it is being referenced by a FOREIGN KEY constraint. →

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

My favourites

Categories

  • Asp.Net (43)
  • Asp.Net Core (3)
  • Asp.Net MVC (5)
  • Asp.Net Rest API (2)
  • ASP.Net Web API (4)
  • C# (45)
  • Entity Framework (1)
  • HTML5 (6)
    • Canvas (5)
  • Interview Questions (178)
    • Asp.Net (10)
    • Asp.Net MVC (32)
    • Asp.Net Web API (1)
    • C# (30)
    • Entity framework (15)
    • JAVA (7)
    • LINQ (6)
    • SQL Server (30)
    • WCF (12)
    • WPF (40)
  • JAVA (32)
    • Design Pattern (3)
    • Hibernate (3)
    • Spring Tutorial (2)
  • JavaScript (3)
  • Jquery (5)
  • Linux (7)
  • Logical Problems (10)
  • My SQL (5)
  • PHP (1)
  • Spring (3)
  • SQL Server (38)
  • Uncategorized (1)
  • Web Service (2)
  • Wicket Framework (2)
  • WPF (1)
  • XML (1)

Recent Posts

  • Global exception handling in asp.net core
  • TempData is null in asp.net core
  • How to disable camel case in asp.net core?
  • Delete, Backspace, Tab and Arrow keys are not working in Firefox when applying validation.
  • How to encode URI components in javascript?

Quick Links

ALL ARTICLES
INTERVIEW QUESTIONS
C# LOGICAL QUESTIONS
FOLLOW
CONTACT US

communities & Groups

Facebook Group

Follow us on social Network

Follow on Facebook Share
Follow on TwitterTweet
Follow on LinkedIn Share
Proudly powered by WordPress
Scroll Up