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/
 


Reply via email to