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 does not exist, but a warning is still generated.
keyvalue_name
specifies the name of the keyvalue to delete.
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 a name does not exist, the error is returned. The [IF EXISTS] clause prevents that error.
Examples
DROP KEYVALUE kvProperties;
DROP KEYVALUE kvMoreFields OF TABLE T1;
DROP KEYVALUE kvMoreFields OF LINK L1;