Was this helpful?
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.
The DROP LOCATION statement has the following format:
[EXEC SQL] DROP LOCATION location_name;
Embedded Usage
You cannot use host language variables in an embedded DROP LOCATION statement.
Permissions
You must have MAINTAIN_LOCATIONS privilege and be connected to the iidbdb.
Locking
The DROP LOCATION statement locks pages in the iilocation_info catalog.
Related Statements
ALTER LOCATION
CREATE LOCATION
MODIFY
Last modified date: 01/30/2023