Creating and Managing User Databases

System administrators use a number of commands and stored procedures to create and manage databases.

This table summarizes the commands for creating, modifying, and dropping user databases and their transaction logs.



create database...on dev_name


alter database...on dev_name

Makes database devices available to a particular SAP ASE database.

When used without the on dev_name clause, these commands allocate space from the default pool of database devices.

dbcc checktable(syslogs)

Reports the size of the log.


Specifies a device that will store the log when the current log device becomes full.


Reports information about a database’s size and devices.


Reports a summary of the amount of storage space used by a database.

Related concepts
System-Defined Segments