Returns a list of databases in Adaptive Server.
sp_databases
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
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. |
Any user can execute sp_databases.
Copyright © 2005. Sybase Inc. All rights reserved. |