Jaa


Creating, Altering, and Removing Indexes

In the SQL Server Management Objects (SMO) hierarchy, indexes are represented by the Index object. The indexed columns are represented by a collection of IndexedColumn objects represented by the IndexedColumns property.

You can create an index on a XML column by specifying the IsXmlIndex property of the Index object.

See Also

Tasks

How to: Create a Non-Clustered, Composite Index in Visual Basic .NET
How to: Create an XML Index in Visual Basic .NET

Reference

Index

Other Resources

Creating Indexes (Database Engine)

Help and Information

Getting SQL Server 2005 Assistance