IndexSqlSchema Element for EventClass (ADF)
Contains Transact-SQL statements for creating one or more indexes on an event table.
Sintaxis
<EventClasses>
<EventClass>
...
<IndexSqlSchema>
Element Characteristics
Characteristic | Description |
---|---|
Data type |
None. |
Default value |
None. |
Occurrence |
Optional once per EventClass element. |
Updates |
Can be added and deleted when updating the application. |
Element Relationships
Relationship | Elements |
---|---|
Parent element |
|
Child elements |
Notas
Importante: |
---|
If you add or delete an IndexSqlSchema element, updating the application 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. Any data existing in the original SQL Server tables is permanently deleted. |
Ejemplo
The following example shows how to create an index named StockIndex on the StockSymbol field of the StockEvents table in the application database.
<IndexSqlSchema>
<SqlStatement>
CREATE INDEX StockIndex
ON StockEvents (StockSymbol)
</SqlStatement>
</IndexSqlSchema>
Vea también
Referencia
Application Definition File Reference
Otros recursos
Definir índices para una clase de evento
Actualizar instancias y aplicaciones