sp_databases

Description

Returns a list of databases in Adaptive Server.

Syntax

sp_databases

Parameters

None.

Examples

Example 1

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

Permissions

Any user can execute sp_databases.