KEYVALUE DELETE

KEYVALUE keyvalue_name [OF TABLE table_name | OF LINK link_name]
    DELETE [LIKE] ( vext_key_list )

vext_key_list
    :    vext_key, ...

vext_key
    :    character_string_literal
    |    variable_name
    |    dynamic_parameter_specification

This command is analog of DELETE command for tables. You can use it to delete the specified key(s) and their corresponded value(s).

LIKE allows you to execute START WITH search for KeyValues WITH KEY, i.e. with KeyValues which have a complex structure of key and which is known to Valentina Database.

You should specify the start of keys, which you want to delete. See example below.

Notice, that KeyValue FOR TABLE and FOR LINK, also are KeyValues WITH KEY, so LIKE search can be used also.

KEYVALUE kvProperties DELETE ( '545.name', '545.age' )

--
-- remove all keys LIKE 545.*
--
KEYVALUE kvProperties DELETE LIKE ( '545' )