SQL SERVER CREATE XML INDEX TROUGH TSQL

USE AdventureWorks2012;
GO
IF EXISTS (SELECT * FROM sys.indexes
            WHERE name = N'PXML_ProductModel_CatalogDescription')
    DROP INDEX PXML_ProductModel_CatalogDescription 
        ON Production.ProductModel;
GO
CREATE PRIMARY XML INDEX PXML_ProductModel_CatalogDescription
    ON Production.ProductModel (CatalogDescription);
GO

http://msdn.microsoft.com/en-us/library/bb934097.aspx

--REMINDER: CREATE NONCLUSTEREDINDEX

--CREATE NONCLUSTERED INDEX IX_TABLE_FIELD ON dbo.TABLE (FIELD);