orientechnologies / orientdb-docs

Repository of the entire OrientDB documentation.
Apache License 2.0
58 stars 167 forks source link

What is the SQL query to delete/drop a user-defined function? #364

Closed pa-emmanuel closed 4 years ago

pa-emmanuel commented 4 years ago

I can create a function with:

CREATE FUNCTION getTest "SELECT count(*) as number FROM People WHERE age = :age" PARAMETERS [age]

But how do I delete this function with SQL.

luigidellaquila commented 4 years ago

Hi @pa-emmanuel

There is no specific SQL command (yet), you can use a plain

DELETE FROM OFunction WHERE name = ?

Thanks

Luigi

pa-emmanuel commented 4 years ago

Hi @pa-emmanuel

There is no specific SQL command (yet), you can use a plain

DELETE FROM OFunction WHERE name = ?

Thanks

Luigi

Thanks Luigi.