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.

Command

Task

create database...on dev_name

or

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.

sp_logdevice

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

sp_helpdb

Reports information about a database’s size and devices.

sp_spaceused

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

Related concepts
System-Defined Segments