SQL - DROP PROPERTY

Removes a property from the schema. Does not remove the property values in the records, it just changes the schema information. Records continue to have the property values, if any.

Syntax

DROP PROPERTY <class>.<property> [IF EXISTS] [FORCE]
  • <class> Defines the class where the property exists.
  • IF EXISTS (since 2.2.13) Drops the property only if it exists. If it doesn't, the statement does nothing
  • <property> Defines the property you want to remove.
  • FORCE In case one or more indexes are defined on the property, the command will throw an exception. Use FORCE to drop indexes together with the property

Examples

  • Remove the name property from the class User:

    orientdb> DROP PROPERTY User.name
    

For more information, see

results matching ""

    No results matching ""