<FieldTypeMods> Element (/EventClass/Schema/Field)
Collapse the table of content
Expand the table of content

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

SQL Server 2000

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


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)

<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
© 2015 Microsoft