Valid in: SQL, ESQL, OpenAPI, ODBC, JDBC, .NET

The ALTER LOCATION statement changes the type of files that can be created at an existing location.

Current usage of the location is unaffected, but future attempts to extend a database to the target extension are constrained by the new usage setting.