SQL query

Monday, 10 March 2014

sql reset id column

  How To: Reset Identity column in SQL Server

Deleted all the existing records

DBCC CHECKIDENT ('TableName', reseed, 0)
Posted by C# Sample Coding at 05:36
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2016 (3)
    • ►  September (1)
    • ►  July (2)
  • ►  2015 (3)
    • ►  August (1)
    • ►  May (1)
    • ►  April (1)
  • ▼  2014 (11)
    • ►  November (1)
    • ►  August (1)
    • ►  May (1)
    • ►  April (5)
    • ▼  March (2)
      • Current database schema, table name, Column name, ...
      • sql reset id column
    • ►  January (1)
  • ►  2013 (17)
    • ►  November (1)
    • ►  October (1)
    • ►  August (2)
    • ►  May (13)

About Me

My photo
C# Sample Coding
PHP
ASP.net
SQL query2008
SYSTEM BASIC
கை வைத்தியம்
சுவையான உணவு
http://kalaiy.blogspot.in
View my complete profile
Ethereal theme. Powered by Blogger.