sa_db_list( [ dbidparm ] )

If you do not specify dbidparm, or if dbidparm is NULL, the IDs for all databases running on the database server are returned. If dbidparm is less than 0, then only the ID for the current database is returned.

Cloud note: Because of tenant database isolation rules, when this system procedure is run in the cloud it returns only information about the current tenant database.

None

None

• sa_conn_list system procedure
• sa_conn_options system procedure
• DB_NAME function [System]

The following example returns the number of databases running on a database server.

SELECT * FROM sa_db_list();

The following example uses the system procedure sa_db_list and the function DB_Name to return a list of the databases running on a database server.

SELECT DB_NAME(Number) FROM sa_db_list();