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).

Parent topic:SQL Commands