次の方法で共有


Type Property (Trigger)

この機能は、将来のバージョンの Microsoft SQL Server では削除される予定です。新規の開発作業ではこの機能を使用しないようにし、現在この機能を使用しているアプリケーションは修正することを検討してください。

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

構文

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.

解説

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:

Trigger Object