Buildmasters Legacy Database Documentation

Index: PK_Region on Region

CollapseAll image

Collapse image Index Properties

 Name   Value 
 ID  2
 Fill Factor  0
 Size, KB  16
 Unique Index 
 Primary Key Index
 Clustered Index 
 Located On  PRIMARY

Collapse image Index Columns

  Name Sort Direction
RegionID ascending

Collapse image Index Statistics Structure and Age

 Name   Value 
Updated 12/13/2004
Average key length 4
Density 0.25
Rows in the table 4
Rows sampled for statistics data 4
Distribution steps 3

Collapse image Extended Properties

No extended properties defined

Collapse image SQL

ALTER TABLE [dbo].[Region]
    ADD
    CONSTRAINT [PK_Region]
    PRIMARY KEY
    NONCLUSTERED
    ([RegionID])
    ON [PRIMARY]
GO

Collapse image See also

Region


Buildmasters.com.au




Buildmasters Legacy Database Documentation