When you use the DZ Table Maintenance window to Drop & Recreate a DynamicZip table, the existing table and related stored procedures will all be deleted. A new copy of the tables and stored procedures will then be created. All records in the old table will be lost. The new table will contain no records.

If you are unable to use the DZ Table Maintenance window to Drop & Recreate a DynamicZip table, you can do so using the SQL Server Management Studio. When you delete the table in SQL Server Management Studio, you will need to delete the related stored procedures also. If any of the related stored procedures still exist from the deleted table, DynamicZip will not be able to recreate the table.

Glossary