8. SQL Statements : DROP LOCATION
Valid in: SQL, ESQL, OpenAPI, ODBC, JDBC, .NET
The DROP LOCATION statement deletes a name that was assigned to a physical disk location using the CREATE LOCATION statement.
Note:  You can drop only a data or work location if no currently existing database has been extended to it. You cannot drop other types of locations.