Export (0) Print
Expand All
Expand Minimize

<SqlStatement> Element (/SubscriptionClass/IndexSqlSchema)

SQL Server 2000

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

Structure
<SubscriptionClasses>
   <SubscriptionClass>
      ...
      <IndexSqlSchema>
         <SqlStatement>

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 (<SubscriptionClass>)
Remarks

If you update a <FieldType> element, 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
Show:
© 2014 Microsoft