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

The results set for sp_databases is:

Column	Datatype	Description
database_name	char(32)	NOT NULL database name.
database_size	int	Size of database, in kilobytes.
remarks	varchar(254)	Adaptive Server always returns NULL.

Permissions

Any user can execute sp_databases.