PXML_Individual_Demographics

CREATE PRIMARY XML INDEX [PXML_Individual_Demographics] ON [Sales].[Individual]([Demographics]);

EXEC [sys].[sp_addextendedproperty] N'MS_Description', N'Clustered index created by a primary key constraint.', N'SCHEMA', [Production], N'TABLE', [Illustration], N'INDEX', [PK_Illustration_IllustrationID];
EXEC [sys].[sp_addextendedproperty] N'MS_Description', N'Clustered index created by a primary key constraint.', N'SCHEMA', [Sales], N'TABLE', [Individual], N'INDEX', [PK_Individual_CustomerID];
EXEC [sys].[sp_addextendedproperty] N'MS_Description', N'Primary XML index.', N'SCHEMA', [Sales], N'TABLE', [Individual], N'INDEX', [PXML_Individual_Demographics];
EXEC [sys].[sp_addextendedproperty] N'MS_Description', N'Secondary XML index for path.', N'SCHEMA', [Sales], N'TABLE', [Individual], N'INDEX', [XMLPATH_Individual_Demographics];
EXEC [sys].[sp_addextendedproperty] N'MS_Description', N'Secondary XML index for property.', N'SCHEMA', [Sales], N'TABLE', [Individual], N'INDEX', [XMLPROPERTY_Individual_Demographics];
EXEC [sys].[sp_addextendedproperty] N'MS_Description', N'Secondary XML index for value.', N'SCHEMA', [Sales], N'TABLE', [Individual], N'INDEX', [XMLVALUE_Individual_Demographics];

Document was prepared on: Thursday, April 05, 2007