Commands and procedures for managing segments

Table 23-2 summarizes the commands and system procedures for managing segments.

Table 23-2: Commands and procedures for managing segments

Command or procedure

Function

sp_addsegment

Defines a segment in a database.

create table and create index

Creates a database object on a segment.

sp_dropsegment

Removes a segment from a database or removes a single device from the scope of a segment.

sp_extendsegment

Adds devices to an existing segment.

sp_placeobject

Assigns future space allocations for a table or an index to a specific segment.

sp_helpsegment

Displays the segment allocation for a database or data on a particular segment.

sp_helpdb

Displays the segments on each database device. See Chapter 21, “Creating and Managing User Databases,” for examples.

sp_help

Displays information about a table, including the segment where the table resides.

sp_helpindex

Displays information about a table’s indexes, including the segments where the indexes reside.