KampData Knowledge Base

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

======How do I drop and recreate a SQL table?======

If you need to delete a DynamicZip table so that you can recreate a fresh empty table, then please follow these steps: 

  - Determine the table(s) to be deleted. 
  - Open the [[dynamiczip:windows:DZ Table Maintenance window]]. 
  - Set the Procedure field to Drop & Recreate. 
  - Insert the table(s) that needs to be dropped and recreated from the Files list into the Selected Files list. **NOTE: **You can view the Total Number of Records field to see how many rows of SQL data are currently stored in the items on the Selected Files list.
  - Press the Process button to drop and recreate the table(s). 
  - Press the Continue button on the pop-up window to complete the process.

----

[[dynamiczip:faq:Frequently Asked Questions]] \\
[[dynamiczip:faq:table_conversion_fail_faq|Table Conversion Fail FAQ]]



\\