sp_objectsegment

Reports the partition name, segment name, and creation date for the specified object.

Syntax

sp_objectsegment object_name

Parameters

object_name – name of the object. Acceptable objects are:
- System tables
- Views
- User tables
- System procedures
- Defaults
- Rules
- Triggers
- Referential constraints
- Check constraints
- Extended types
- Functions
- Computed columns
- Partitions

Examples

Example 1 – Reports information about the authors table:

sp_objectsegment authors

Partition_name    Data_located_on_segment     When_created
-----------------  -----------------------     ------------
auidind_576002052                   default     Feb  9 2012 11:18AM

Permissions

Any user may run sp_objectsegment.