ALTER EXTERNAL LOCATION ​

Alter an external location object.

ALTER EXTERNAL LOCATION name 
[ PATH string ]
[ EXTERNAL STORAGE name ]
[ EXTERNAL FORMAT name ]

For example, alter the path and the external storage object for a location:

premdb=> alter external location premdbazuredata path 'premdbnew' external storage "premdbAzure";
ALTER EXTERNAL LOCATION

You must have the correct privileges to run this command. See ON EXTERNAL object.

You cannot alter the USAGE of an external location (PRIMARY or EXTERNAL).