Returns the table alias of the current or specified work area.

ALIAS([nWorkArea | cTableAlias])

Parameters

nWorkArea

Specifies the work area number for which ALIAS( ) returns the table alias.

cTableAlias

Specifies the table alias for which ALIAS( ) returns the table alias.

If you omit nWorkArea or cTableAlias, ALIAS( ) returns the alias of the table open in the current work area. An empty string is returned if a table isn't open in the current or specified work area.

Return Value

Example

The following example opens the customer table and displays its alias. The customer table is opened again in another work area, is assigned an alias of MyCustomer, and the alias is displayed.

	Copy Code
CLOSE DATABASES OPEN DATABASE (HOME(2) + 'Data\testdata') USE customer && Open customer table CLEAR ? ALIAS( ) && Display the alias SELECT 0 USE customer AGAIN ALIAS MyCustomer && Different alias ? ALIAS( ) && Display the alias

See Also