System-Defined Segments

When you create a database, SAP ASE creates three segments in the database.

If you create a database on a single database device, the system, default, and logsegment segments are created on the same device. If you use the log on clause to place the transaction log on a separate device, the segments resemble those shown below:

System-Defined Segments
Graphic describing a situation where the system and default segments are on a separat device from the log segment.

Although you can add and drop user-defined segments, you cannot drop the default, system, or log segments from a database. A database must have at least one of each type of system-defined segment: system, logsegment, and default.

These are the commands and system procedures for managing segments:
Related concepts
Creating and Managing User Databases