Sign Up for Training |
insightsoftware Company Site
Community
Downloads
Training
Submit a Request
Become a Jet Insider
Give Feedback

There is already an object <table name> in the database


Expert

Overview

When Deploying the project, you get an error message that contains "There is already an object name 'table name' in the database."

mceclip0.png

Applicable text of error message is:

...  There is already an object named 'table name' in the database...

Before taking these steps, it is strongly advised to ensure you have a backup of your databases involved.

Resolution Steps

  1. Find the database that contains the table in the error message. In the case above, we were Deploying the Staging database, so you'd want to open the Staging database node of the project.

  2. Right-click on the database, go to Advanced, and select SQL Database Cleanup Wizard.

    mceclip1.png

  3. The SQL Cleanup Wizard will then run. 

    If there are no objects to clean up you will get a message saying there was nothing found.

  4. If the Cleanup Wizard does find objects, a window will open and you will have the option of dropping objects. We recommend Right-Clicking the Project Header and selecting the Drop option.

    mceclip2.png

  5. Once you've dropped the objects, Deploy and Execute the database.

    mceclip3.png

     

     

After following these steps, if you continue to get this error, you may need to recreate the database from scratch.  If this is something you need assistance with, please contact the Jet Global Support Team.

Was this article helpful?
0 out of 0 found this helpful

Comments