reset Autonumber primary key - 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

General SQL Server Forums

New to SQL Server Programming

reset Autonumber primary key

Author

Topic

jarv
Posting Yak Master

131 Posts

Posted - 2007-08-02 : 04:18:28

Ho wdo i do this? when i delete records and then post a new one from the start I want that to be number 1? I am using MSSQL

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-08-02 : 04:25:42

DBCC CHECKIDENT

E 12°55'05.25"
N 56°04'39.16"

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-08-02 : 04:26:18

If you meant you want to delete all records and reset it, then truncate the table

Truncate table TableName

Madhivanan

Failing to plan is Planning to fail

jarv
Posting Yak Master

131 Posts

Posted - 2007-08-02 : 06:18:09

how do i do that?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-08-02 : 07:01:43

???

Madhi just explained and wrote the code for you!

TRUNCATE TABLE <Your Table Name Here>

E 12°55'05.25"
N 56°04'39.16"

jarv
Posting Yak Master

131 Posts

Posted - 2007-08-02 : 09:59:42

do i put that in the SQL string?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-08-02 : 10:23:27

It depends. What do you mean "sql string"?
We don't have access to your code, and we don't like to guess either.

E 12°55'05.25"
N 56°04'39.16"

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-08-02 : 10:24:54

no

1. open BOL = Books Online = Sql server help
2. type "Truncate table" in the search box
3. go to first result

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

drewsalem
Constraint Violating Yak Guru

304 Posts

Posted - 2007-08-02 : 10:56:07

Are you still having problems, Jarv?

Drew
---------------------
"It's Saturday night; I've got no date, a two litre bottle of Shasta, and my all-Rush mix tape... LET'S ROCK."

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-08-02 : 11:01:01

you're in a helping mood today drew

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2007-08-03 : 12:07:53

"I am using MSSQL"
How about, you are connecting to "MSSQL" through a front end, like javascript or some such....

[Signature]For fast help, follow this link:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx
Learn SQL
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources