LISTLOCATIONS

Displays all location aliases defined on the current database.

Syntax

LISTLOCATIONS

Notes

This command displays the location alias parameters as defined and created with the CREATELOCATION command. You must have at least Database Manager permission to list location aliases.

Example

LISTLOCATIONS;

Returns:

Location Alias  Server      Application    Database     Username
--------------- ----------- -------------- ------------ ---------------
Alias4          Aspen       Sample         Interntl     admin
Alias3          Aspen       Demo           Basic        user1
Alias2          Aspen       Samppart       Company      partitionuser
Alias1          Aspen       Sample         Basic        Admin

See Also