Index: PK_CustomerCustomerDemo on CustomerCustomerDemo

Collapse All Expand All

Index Properties

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

Index Columns

	Name	Sort Direction
	CustomerID	ascending
	CustomerTypeID	ascending

Extended Properties

SQL

ALTER TABLE [dbo].[CustomerCustomerDemo]
    ADD
    CONSTRAINT [PK_CustomerCustomerDemo]
    PRIMARY KEY
    NONCLUSTERED
    ([CustomerID], [CustomerTypeID])
    ON [PRIMARY]
GO

See also

Buildmasters.com.au