Index: CompanyName on Customers

Collapse All Expand All

Index Properties

Name	Value
ID	3
Fill Factor	0
Size, KB	16
Unique Index
Primary Key Index
Clustered Index
Located On	PRIMARY
Ignore Duplicates
Don't Recompute Statistics
Pad Index

Index Columns

	Name	Sort Direction
	CompanyName	ascending

Extended Properties

SQL

CREATE INDEX [CompanyName]
    ON [dbo].[Customers] ([CompanyName])
    ON [PRIMARY]
GO

See also

Buildmasters.com.au