[dba-SQLServer] Truncating Temporary Tables

David Emerson newsgrps at dalyn.co.nz
Tue Jul 8 12:55:49 CDT 2008


Is it possible to truncate a temporary table in SQL2000?

I have a table defines as follows:

DECLARE @ttmpGoalIns TABLE (RowID int IDENTITY (1, 1) NOT NULL, 
GoalID int, Description varchar(100), GoalAmt money DEFAULT (0) )

During my code I want to delete the rows and reset the identity back 
to 1.  Truncate is supposed to do this but I get an Incorrect Syntax 
error on the line:

TRUNCATE TABLE @ttmpGoalIns


Regards

David Emerson
Dalyn Software Ltd
Wellington, New Zealand 


More information about the dba-SQLServer mailing list