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
<*> 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/