Switch to: V9V8V7V6V5

DROP KEYVALUE

DROP KEYVALUE statement is used to remove a keyvalue specified by its name.

Syntax

DROP KEYVALUE [IF EXISTS]
    : keyvalue_name 
DROP KEYVALUE [IF EXISTS]
    : keyvalue_name OF { TABLE table_name | LINK link_name }

Arguments

[IF EXISTS]

this clause prevents error if a keyvalue with the given name not exists, but warning still is generated.

keyvalue_name

specifies the name of a keyvalue to be dropped.

OF TABLE

This form allows you to delete KEYVALUE FOR TABLE.

OF LINK

This form allows you to delete KEYVALUE FOR LINK.

Possible Errors

  • If KeyValue with such name does not exist, the error is returned. The [IF EXISTS] clause prevent that error.

Examples

DROP KEYVALUE kvProperties;
DROP KEYVALUE kvMoreFields OF TABLE T1;
DROP KEYVALUE kvMoreFields OF LINK L1;