Gets the collection of Transact-SQL statements for creating one or more indexes for the subscription class.
Namespace: Microsoft.SqlServer.Management.Nmo Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
Use the StringCollection methods to modify the collection of statements.
If you alter the indexing statements, updating the application re-creates the subscription class to which it corresponds. Notification Services renames the existing subscription tables by appending Old to the table name and then creates new tables. 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. For more information, see Updating an Application.