Four system procedures provide information about segments:
sp_helpsegment lists the segments in a database or displays information about a particular segment in the database.
sp_helpdb displays information about the relationship between devices and segments in a database.
sp_help and sp_helpindex display information about tables and indexes, including the segment to which the object is assigned.
