Table of Contents
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;