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

Error: Cannot DROP TABLE 'dbo.Parameters_V'


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'.


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