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

Error: Cannot DROP TABLE 'dbo.Parameters_V'


Symptoms

When attempting to deploy your custom Parameters table after implementing a custom function (i.e. 'Asian Characters' fix), you encounter the following error:

"Cannot DROP TABLE 'dbo.Parameters_V' because it is being referenced by object 'BusinessUnitNAV_dbo_[TABLENAME]Transform'.

Resolution

This can be resolved by simply unchecking the Bind Functions option within the corresponding table's settings.  To do so, right-click on the table and select Table Settings.

 

In the dialog box that opens, navigate to the Performance tab and un-check the box for Bind Functions.

 

After adjusting the tables settings, you will need to re-deploy it so that the changes are made against the database.

Once re-deployed, you will then be able to deploy the original table in question, 'dbo.Parameters_V'.  

 

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

Comments