Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Dropping old DBD schemas
Hi
I am trying to drop old V_DBD schemas, this is my exception:
SELECT DESIGNER_DROP_DESIGN ('ctx_EncodingDesign');
Result:[Code: 4983, SQL State: VD001] [Vertica][VJDBC](4983) ERROR: There is no design tables system table in workspace ctx_EncodingDesign
Any ideas what is the problem?
THX
0
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
Comments
Hi,
See if you can drop the work space:
select dbd_drop_workspace('ctx_EncodingDesign');
Then try dropping the design again and it should report that it does not exist.
it works, thanks!