use truncate table tableEmployee -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Matthew Macdonald-Wallace Sent: Monday, July 04, 2005 12:37 PM To: [email protected] Subject: [AspNetAnyQuestionIsOk] [OT] SQL "Flush" Equivelent?
Hi all, not sure what the policy is for Off-Topic postings here, and I'm not sure if this is really off-topic, so please let me know! :o) I've currently got a database with a number of tables using "IDENTITY" columns as a primary key. I've been testing this system for a while now and as a result, I've got loads of useless information sitting in my tables. Under MySQL, there is a "FLUSH" (or similar!) command that deletes all the information from the table and resets the IDENTITY to its original value (in this case, 1). Is there a command that does the same under MSSQL 2003? I've tried googling for this, but don't think I'm typing in the correct phrase. TIA, Matt Yahoo! Groups Links This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. Any unauthorised review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly prohibited and may be unlawful. Visit us at http://www.cognizant.com 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/
