Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
<IndexSqlSchema> Node (<EventClass>)
Collapse the table of content
Expand the table of content

<IndexSqlSchema> Node (<EventClass>)

SQL Server 2000

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

Structure
<EventClasses>
   <EventClass>
      ...
      <IndexSqlSchema>

Node Characteristics
Characteristic Description
Occurrence Optional once per <EventClass> node.
Updates Can be added and deleted using NSControl Update.
Node Relationships
Relationship Elements
Parent Node <EventClass> Node
Child Elements <SqlStatement> Element (/EventClass/IndexSqlSchema)
Remarks

If you add or delete an <IndexSqlSchema> node, NSControl Update deletes and re-creates the event class to which it corresponds. This includes dropping and re-creating the SQL Server tables and indexes used by this event class.

Important  If you add or delete an <IndexSqlSchema> node, any data existing in the original SQL Server tables is permanently deleted.

See Also
Creating the Indexing Statement
Show:
© 2015 Microsoft