SQL Language Guide : 7. 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;
DROP LOCATION Example
Delete the extra_work_disk location:
DROP LOCATION extra_work_disk;