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

Comments

  • Jim_KnicelyJim_Knicely Administrator

    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!

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.