Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to alter the identity property ?
- Thread starter magdyk
- Start date
tlbroadbent
MIS
Use DBCC CHECKIDENT (<table_name>, RESEED, <new seed>)
Example:
DBCC CHECKIDENT (Employees, RESEED, 1001)
Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.
- Status
Similar threads
- Locked
- Question