Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

<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
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.