Chapter 6: Creating and Managing User Databases

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.