<IndexSqlSchema> Node (<EventClass>)
Provides a location for specifying the Transact-SQL statements needed for creating one or more indexes on an event table.
<EventClasses> <EventClass> ... <IndexSqlSchema>
|Occurrence||Optional once per <EventClass> node.|
|Updates||Can be added and deleted using NSControl Update.|
|Parent Node||<EventClass> Node|
|Child Elements||<SqlStatement> Element (/EventClass/IndexSqlSchema)|
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.