Index: LastName on Employees

Collapse All Expand All

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

Index Columns

	Name	Sort Direction
	LastName	ascending

Extended Properties

SQL

CREATE INDEX [LastName]
    ON [dbo].[Employees] ([LastName])
    ON [PRIMARY]
GO

See also

Buildmasters.com.au