<SqlStatement> Element (/EventClass/IndexSqlSchema)
Collapse the table of content
Expand the table of content

<SqlStatement> Element (/EventClass/IndexSqlSchema)

SQL Server 2000

Specifies a Transact-SQL statement to create a SQL Server index on the event table.


Element Characteristics
Characteristic Description
Data Type string, between 1 and 100,000 characters in length.
Default Value None.
Occurrence Optional once or more per <IndexSqlSchema> node.
Updates Can be added, deleted, and modified using NSControl Update.
Element Relationships
Relationship Elements
Parent Node <IndexSqlSchema> Node (<EventClass>)

If you add, delete, or update a <SqlStatement> element, 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, delete, or update a <SqlStatement> element, any data existing in the original SQL Server tables is permanently deleted.

See Also
Creating the Indexing Statement
© 2016 Microsoft