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;