Support IF NOT EXISTS and IF EXISTS for CREATE and DROP commands

[vertex-github]

Being able to create/drop tables/classes without errors is very helpful.

[yujinlim]

+1

[AlexanderRay]

+1

[baojie]

+1

[pisaruk]

+1

[rmchale]

+1

[smolinari]

+1

[mscarlett]

+1

[elexx]

+1

[stein321]

+2

[matteoredaelli]

+2

[StarpTech]

+1

[micha-heigl]

+1

[micha-heigl]

would be very helpful for create property to create migration scripts

[malibuworkcrew]

+1

[smolinari]

@luigidellaquila - another one to mark as an API Improvement. 😉

Scott

[luigidellaquila]

Hi guys,

this seems to be next most voted enhancement (after #1114), I think it will go high priority soon ;-)

Thanks

Luigi

[DevMoore94]

+1

[tintinweb]

+1

[luigidellaquila]

Hi guys,

This is one of the most voted issues in our issue tracker, so I'm happy to announce that this feature will be available in v 2.2.13 for

• CREATE CLASS
• DROP CLASS
• CREATE PROPERTY
• DROP PROPERTY

Thanks!

Luigi

[luigidellaquila]

See full syntax:

http://orientdb.com/docs/2.2.x/SQL-Create-Class.html
http://orientdb.com/docs/2.2.x/SQL-Drop-Class.html
http://orientdb.com/docs/2.2.x/SQL-Create-Property.html
http://orientdb.com/docs/2.2.x/SQL-Drop-Property.html

[smolinari]

@luigidellaquila - Hey Luigi,

If you think about it, with a full NoSQL ODB, all this would be baked into ODB and the DDL wouldn't be needed. 😜

Thanks for the improvement though. For full SQL ODB, it is a nice addition.

Scott

[saeedtabrizi]

Hi @luigidellaquila
Thanks to hear my voice :)
#6063 . so you can close(partially) this issue .
Is there any plan for implementing the TTL feature on the next release ?

Thanks
Saeed Tabrizi