sa_db_info( [ dbidparm ] )

If you specify a database ID, sa_db_info returns a single row containing the Number, Alias, File, ConnCount, PageSize, and LogName for the specified database.

If dbidparm is greater than zero, then properties for the supplied database are returned. If dbidparm is less than zero, then properties for the current database are returned. If dbidparm is not supplied or is NULL, then properties for all databases running on the database server are 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.

No privileges are required to execute this system procedure for the current database. To execute this system procedure for other databases, you must have either the SERVER OPERATOR or MONITOR system privilege.

None

• sa_db_properties system procedure
• List of database properties

The following statement returns a row for each database that is running on the server:

CALL sa_db_info( );