共用方式為


Trigger Object

未來的 Microsoft SQL Server 發行版本將不再提供此功能。請避免在新的開發工作中使用此功能,並計劃修改目前使用此功能的應用程式。

The Trigger object exposes the attributes of a single Microsoft SQL Server trigger.

顯示目前物件的 SQL-DMO 物件模型

Properties

AnsiNullsStatus Property

Owner Property (Database Objects)

CreateDate Property

QuotedIdentifierStatus Property

Enabled Property

SystemObject Property

ID Property

Text Property

Name Property

Type Property (Trigger)

Methods

Alter Method

Remove Method (Objects)

EnumDependencies Method

Script Method

備註

SQL Server supports using triggers as a kind of stored procedure. Triggers are run when a specified data modification, such as an attempt to delete a row, is attempted on the table on which the trigger is defined. With the Trigger object, you can:

  • Create a SQL Server trigger on an existing SQL Server table.
  • Remove an existing SQL Server trigger from a SQL Server table.
  • Generate a Transact-SQL script to use in other tools to re-create an existing SQL Server trigger.
  • Change ownership of an existing SQL Server trigger.

The Name property of a Trigger object is a character string. The value of the property identifies a SQL Server trigger by name and must conform to the rules for trigger naming. The Name property is required when creating a SQL Server trigger.

To create a trigger on an existing SQL Server table

  1. Create a Trigger object.

  2. Set the Name property.

  3. Set the Text property to contain the Transact-SQL script defining the SQL Server trigger behavior. For more information about trigger scripts, see CREATE TRIGGER (Transact-SQL).

  4. Get the Table object referencing the SQL Server table you want from the Tables collection of the appropriate Database object.

  5. Use the BeginAlter method of the Table object to mark the start of changes to the SQL Server table definition.

  6. Add the new Trigger object to the Triggers collection of the selected Table object.

  7. Use the DoAlter method of the Table object to mark the end of changes and create the SQL Server trigger.

ms135728.note(zh-tw,SQL.90).gif附註:
The Trigger object is compatible with instances of SQL Server versions 7.0 and later. However, the Trigger2 object extends the functionality of the Trigger object for use with features that were introduced in SQL Server 2000.

請參閱

參考

Trigger2 Object

說明及資訊

取得 SQL Server 2005 協助