Index: PK_Department_DepartmentID on table HumanResources.Department
Index: PK_Department_DepartmentID on table HumanResources.Department
| Clustered Index: | |
| Primary Key Index: | |
| Unique Index: | |
| Ignore Duplicates: | |
| Pad Index: | |
| Allow Row Locks: | |
| Allow Page Locks: | |
| Is computed column in index: | |
| Located On: | PRIMARY |
| Size KB: | 24 |
| Fill Factor: | 0 |
| Don't Recompute Statistics: | |
| Description: | Primary key (clustered) constraint |
| Name | Descending | Included | |
| DepartmentID |
| Updated: | Apr 26 2006 11:49AM |
| Average key length: | 2 |
| Density: | 1 |
| Rows in the table: | 16 |
| Rows sampled for statistics data: | 16 |
| Distribution steps: | 9 |
CREATE UNIQUE CLUSTERED INDEX [PK_Department_DepartmentID] ON [HumanResources].[Department]([DepartmentID]) ON [PRIMARY]
GO
See Also
List of indexes