To delete a user-defined table

  1. Make sure all other users exit the iMIS system.
  2. Back up your data.
  3. Log into iMIS with the MANAGER logon.
  4. From Customers, select Set up module > General, and click Additional Windows to open the Customer Setup – Additional Windows window.
  5. Click Define Tables to open the User Defined Tables window.
  6. Select the table you want to delete from the Table Name drop-down list.
  7. Click Delete. iMIS prompts you to confirm the deletion.
  8. Click Yes to delete the table.
  9. Click Cancel to close the User Defined Tables window.
  10. Use SQL Server tools to drop the user-defined table that was deleted.
  11. Exit iMIS immediately.