Buildmasters Legacy Database Documentation

Index: CategoryName on Categories

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
 Ignore Duplicates 
 Don't Recompute Statistics 
 Pad Index 

Collapse image Index Columns

  Name Sort Direction
CategoryName ascending

Collapse image Index Statistics Structure and Age

 Name   Value 
Updated 08/25/2008
Average key length 25
Density 1
Rows in the table 8
Rows sampled for statistics data 8
Distribution steps 7

Collapse image Extended Properties

No extended properties defined

Collapse image SQL 

CREATE INDEX [CategoryName]
    ON [dbo].[Categories] ([CategoryName])
    ON [PRIMARY]
GO

Collapse image See also

Categories

Buildmasters.com.au



Buildmasters Legacy Database Documentation