Reseting the identity seed - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Reseting the identity seed

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-09-06 : 09:13:32

James writes "I was just wondering if there is anyway to reset the identiy seed to 1.

I know i can drop the table create it again, and the identity seed will start at 1, but is there any other way?

thanks"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources