These 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.
