in sql: truncate tablename
----- Original Message ----- From: "Eva Li" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Thursday, July 21, 2005 3:45 PM Subject: [AspNetAnyQuestionIsOk] How to reset AutoNumber (Identity ) in SQL database > Hi All, > > Can any body tell me how to reset AutoNumber, i.e. identity value starting > from 1? > > I'd like to clean all the testing data from SQL database and have the > identity value > start from 1. I used to generate script and recreate tables. I think > there should be > a way to do this without recreating the table. Any body knows how? > > Thanks! > > Eva > > > [Non-text portions of this message have been removed] > > > > > Yahoo! Groups Links > > > > > > Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
