Dropping old DBD schemas

ohadmata

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

Jim_Knicely

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.

ohadmata

it works, thanks!