<IndexSqlSchema> Node (<SubscriptionClass>)
Collapse the table of content
Expand the table of content

<IndexSqlSchema> Node (<SubscriptionClass>)

SQL Server 2000

Provides a location for specifying the Transact-SQL statements needed for creating one or more indexes on a subscription table.


Node Characteristics
Characteristic Description
Occurrence Optional once per <SubscriptionClass> node.
Updates Can be added and deleted using NSControl Update.
Node Relationships

If you add or delete an <IndexSqlSchema> node, NSControl Update re-creates the subscription class to which it corresponds. A new subscription table is created, and the existing subscription table is renamed to SubscriptionTableNameOld. Existing subscription table indexes are left unchanged. If you want to transfer data between the old and new subscription tables, it must be done manually.

See Also
Creating the Indexing Statement
© 2015 Microsoft