sp_databases

Description

Returns a list of databases in Adaptive Server.

Syntax

sp_databases

Parameters

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	bigint	Size of database, in kilobytes.
  remarks	varchar(254)	Adaptive Server always returns NULL.

Permissions

Any user can execute sp_databases.