Type Property (Trigger)

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The Type property exposes configured attributes of the referenced Microsoft SQL Server component.

Syntax

object.Type

Parts

  • object
    An expression that evaluates to an object in the Applies To list

Data Type

Long, enumerated

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetType(SQLDMO_TRIGGER_TYPE* pRetVal)

Returns

For a Trigger object, interpret the Type property using these values.

Constant

Value

Description

SQLDMOTrig_All

7

Fired by any data modification statement.

SQLDMOTrig_Delete

4

Fired by a DELETE statement.

SQLDMOTrig_Insert

1

Fired by an INSERT statement.

SQLDMOTrig_Unknown

0

The value is not valid.

SQLDMOTrig_Update

2

Fired by an UPDATE statement.

Remarks

A SQL Server trigger can fire when a Transact-SQL INSERT, UPDATE, or DELETE statement modifies data in the table on which the trigger is defined.

The Transact-SQL script defining the trigger determines the Transact-SQL statements that cause firing. For more information, see Text Property.

Applies To: