Export (0) Print
Expand All
Expand Minimize

<FieldTypeMods> Element (/EventClass/Schema/Field)

SQL Server 2000

Specifies optional SQL Server field attributes for an event field, such as null and default values.

Structure
<EventClasses>
   <EventClass>
      ...
      <Schema>
         <Field>
            ...
            <FieldTypeMods>

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

<FieldTypeMods> values must conform to SQL Server Transact-SQL syntax conventions. For more information about this syntax, see "CREATE TABLE" in SQL Server Books Online.

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

See Also
Defining the Event Fields
Show:
© 2014 Microsoft