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

CREATE PROPERTY

SQL Commands

Console Commands

results matching ""

No results matching ""