Commands for creating and managing user databases

Table 6-1 summarizes the commands for creating, modifying, and dropping user databases and their transaction logs.

Table 6-1: Commands for managing user databases

Command

Task

create database...on dev_name

or

alter database...on dev_name

Makes database devices available to a particular Adaptive Server 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.