The SQL Drop Index command removes an index on a property defined in the schema.

    DROP INDEX <index-name>|<class>.<property>

Where:

• class is the class of the schema
• property, is the property created into the class

    DROP INDEX users.Id

For complete index guide look at Index guide.

To know more about other SQL commands look at SQL commands.