Hi Eric,
Thanks for the info. I can't use Truncate table on a table referenced by a foreign key constraint.
I'll have to figure out a way to delete the constraints - before truncating the tables - and then rebuild them once all appropriate tables have been truncated.
Al
>instead of deleting rows, you can truncate them (which delete ALL rows and reset identity columns).
>
>truncate table YourTableName
>
>
>>Hi,
>>
>>We will soon be ready to move a VB-SQL 2000 app from testing to production. We will be deleting records from most of the tables (excluding some settings tables) accumulated during testing. Creating a SQL script to do this is simple enough.
>>
>>My question is this: I would like to reset the identity seed for these tables after deleting the records. How should I do this? Can it be done as part of my script?
>>
>>Thanks in advance.
>>
>>Al
Al Williams
Anola MB, CANADA