ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

NEXT_DATABASE function [System]

Function 

Returns an identifying number for a database.

Syntax 

NEXT_DATABASE ( { NULL | database-id } )

Parameters 

database-id     An integer that specifies the ID number of the database.

Usage 

NEXT_DATABASE can be used to enumerate the databases running on a database server. To get the first database pass NULL; to get each subsequent database, pass the previous return value. The function returns NULL when there are no more databases.

Standards and compatibility 

• SQL/92    Transact-SQL extension.

• SQL/99    Transact-SQL extension.

• Sybase    Not supported by Adaptive Server Enterprise.

Example 

The following statement returns the value 0, the first database value.

SELECT NEXT_DATABASE( NULL )

The following statement returns NULL, indicating that there are no more databases on the server.

SELECT NEXT_DATABASE( 0 )