SQL Language Guide : 8. SQL Statements : DROP LOCATION
 
Share this page                  
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.
Notes:
You must be connected to the iidbdb database to issue CREATE/ALTER/DROP LOCATION statements.
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.
This statement has the following format:
DROP LOCATION location_name;