LISTLOCATIONS

Displays all location aliases defined on the current database.

Syntax

LISTLOCATIONS

Description

This command displays the location alias parameters as defined and created with the CREATELOCATION command. You must have at least Database Designer 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

CREATELOCATION
DELETELOCATION

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com