sp_databases

Returns a list of databases in the SAP ASE server.

Syntax

sp_databases

Examples

Example 1 – Returns a list of databases in the server:

sp_databases

database_name       database_size    remarks
----------------    -------------    ------------
master                 5120          NULL
model                  2048          NULL
mydb                   2048          NULL
pubs2                  2048          NULL
sybsecurity            5120          NULL
sybsystemprocs        16384          NULL
tempdb                 2048          NULL

Usage

The results set for sp_databases is:

Column	Datatype	Description
`database_name`	`char(32)`	NOT NULL database name.
`database_size`	`bigint`	Size of database, in kilobytes.
`remarks`	`varchar(254)`	SAP ASE always returns NULL.

Permissions

Any user can execute sp_databases.