[orientdb] How to delete a property of a schema-less document?

[florin]

Even when all values of all documents are set to NULL, the property
remains.

This is all I can find:

"The *Drop Property* command removes a property from the schema. This
doesn't remove the property values in records, but just change the schema
information. Records will continue to have the property values if any."
(http://www.orientechnologies.com/docs/last/orientdb.wiki/SQL-Drop-Property.html).


However, there's got to be way to remove a property when no document has
any more values?

Thanks.

[Luigi Dell'Aquila]

Hi Florin,

null is a valid value for a property, so setting it to null just leaves it
there, in the document.
If you want to completely remove a property you have to use this statement:

update MyClass remote myPropertyName where...

regards

Luigi

Post by florin
Even when all values of all documents are set to NULL, the property
remains.
"The *Drop Property* command removes a property from the schema. This
doesn't remove the property values in records, but just change the schema
information. Records will continue to have the property values if any." (
http://www.orientechnologies.com/docs/last/orientdb.wiki/SQL-Drop-Property.html).
However, there's got to be way to remove a property when no document has
any more values?
Thanks.
--
---
You received this message because you are subscribed to the Google Groups "OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an
For more options, visit https://groups.google.com/d/optout.

[florin]

Thanks!

Post by Luigi Dell'Aquila
Hi Florin,
null is a valid value for a property, so setting it to null just leaves it
there, in the document.
update MyClass remote myPropertyName where...
regards
Luigi

Post by florin
Even when all values of all documents are set to NULL, the property
remains.
"The *Drop Property* command removes a property from the schema. This
doesn't remove the property values in records, but just change the schema
information. Records will continue to have the property values if any." (
http://www.orientechnologies.com/docs/last/orientdb.wiki/SQL-Drop-Property.html).
However, there's got to be way to remove a property when no document has
any more values?
Thanks.
--
---
You received this message because you are subscribed to the Google Groups
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an
For more options, visit https://groups.google.com/d/optout.

[Luigi Dell'Aquila]

oh, sorry, I saw only now that I wrote "remote" instead of "remove" ;-)

anyway you got the point :)

Luigi

Post by florin
Thanks!

Post by Luigi Dell'Aquila
Hi Florin,
null is a valid value for a property, so setting it to null just leaves
it there, in the document.
update MyClass remote myPropertyName where...
regards
Luigi

Post by florin
Even when all values of all documents are set to NULL, the property
remains.
"The *Drop Property* command removes a property from the schema. This
doesn't remove the property values in records, but just change the schema
information. Records will continue to have the property values if any." (
http://www.orientechnologies.com/docs/last/orientdb.wiki/
SQL-Drop-Property.html).
However, there's got to be way to remove a property when no document has
any more values?
Thanks.
--
---
You received this message because you are subscribed to the Google
Groups "OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send
For more options, visit https://groups.google.com/d/optout.

--

---
You received this message because you are subscribed to the Google Groups "OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an
For more options, visit https://groups.google.com/d/optout.