Trigger 成員
The Trigger object represents a SQL Server trigger.
Trigger 型別公開下列成員。
建構函式
| 名稱 | 描述 | |
|---|---|---|
.gif "公用方法") |
Trigger() () () () | Initializes a new instance of the Trigger class. |
|
Trigger(SqlSmoObject, String) | Initializes a new instance of the Trigger class on the specified object, and with the specified name. |
頂端
方法
.gif "受保護的方法")
頂端
.gif "受保護的欄位")
屬性
| 名稱 | 描述 | |
|---|---|---|
.gif "公用屬性") |
AnsiNullsStatus | Gets the Boolean property value that specifies whether ISO NULL handling is enabled in the trigger. |
|
AssemblyName | Gets or sets the name of the .NET assembly that is required by the referenced trigger. |
|
ClassName | Gets or sets the name of the class that is called by the referenced trigger. |
|
CreateDate | Gets the date and time when the trigger was created. |
|
DateLastModified | Gets the date and time when the trigger was last modified. |
|
Delete | Gets or sets the Boolean property value that specifies whether the trigger is executed when records are deleted from the table. |
|
DeleteOrder | Gets or sets the order in which the trigger and the delete operation are executed. |
|
Events | Gets the events that are associated with the trigger. |
.gif "受保護的屬性") |
ExecuteForScalar | Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (繼承自 SqlSmoObject。) |
|
ExecutionContext | Gets or sets the execution context. |
|
ExecutionContextPrincipal | Gets or sets the execution context principal. |
|
ExtendedProperties | Gets the extended properties of the Trigger object. |
|
ID | Gets the ID value that uniquely identifies the trigger. |
|
ImplementationType | Gets or sets the implementation type of the trigger. |
|
Insert | Gets or sets the Boolean property value that specifies whether the trigger is fired when records are inserted into the table. |
|
InsertOrder | Gets or sets the order in which the trigger and the insert operation are executed. |
|
InsteadOf | Gets or sets a Boolean property that specifies whether the trigger runs instead of the insert, delete, or update operation. |
|
IsEnabled | Gets or sets the Boolean property that specifies whether the trigger is enabled. |
|
IsEncrypted | Gets or sets the Boolean property value that specifies whether the trigger is encrypted. |
|
IsSystemObject | Gets the Boolean property value that specifies whether the trigger is a system object. |
|
IsTouched | Gets the Boolean property value that specifies whether the object properties have been updated but not yet persisted on the server. (繼承自 SqlSmoObject。) |
|
MethodName | Gets the method name for the trigger. |
|
Name | Gets or sets the name of the object. (繼承自 NamedSmoObject。) |
|
NotForReplication | Gets or sets a Boolean property value that specifies whether the trigger is included in replication operations. |
|
ObjectInSpace | Gets the Boolean property value that specifies whether the object exists in isolation, or whether it is directly or indirectly connected to the instance of SQL Server. (繼承自 SqlSmoObject。) |
|
Parent | Gets or sets the SqlSmoObject object that is the parent of the Trigger object. |
|
Properties | Gets a collection of Property objects that represent the object properties. (繼承自 SqlSmoObject。) |
|
QuotedIdentifierStatus | Gets or sets a Boolean property value that specifies whether identifiers delimited by double quotation marks are Transact-SQL reserved keywords or contain characters not usually allowed by the Transact-SQL syntax rules. |
|
ScalarResult | Gets the scalar result for the referenced object. (繼承自 SqlSmoObject。) |
|
State | Gets the state of the referenced object. (繼承自 SmoObjectBase。) |
|
TextBody | Gets or sets the Transact-SQL string that defines the trigger. |
|
TextHeader | Gets or sets the header part of the Transact-SQL string that defines the trigger. |
|
TextMode | Gets or sets the Boolean property that specifies whether the text header is editable as text. |
|
Update | Gets or sets the Boolean property value that specifies whether the trigger is fired when records are updated in the table. |
|
UpdateOrder | Gets or sets the order in which the trigger and the update operation are executed. |
|
Urn | Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (繼承自 SqlSmoObject。) |
|
UserData | Gets or sets user-defined data associated with the referenced object. (繼承自 SmoObjectBase。) |
頂端
.gif "公用事件")
明確繼承實作
| 名稱 | 描述 | |
|---|---|---|
.gif "明確介面實作") .gif "私用方法") |
IAlienObjectDiscover | (繼承自 SqlSmoObject。) |
|
IAlienObjectGetParent | (繼承自 SqlSmoObject。) |
|
IAlienObjectGetProperty | (繼承自 SqlSmoObject。) |
|
ISfcPropertyProviderGetPropertySet | (繼承自 SqlSmoObject。) |
|
IAlienObjectGetUrn | (繼承自 SqlSmoObject。) |
|
IAlienObjectResolve | (繼承自 SqlSmoObject。) |
|
IAlienObjectSetProperty | (繼承自 SqlSmoObject。) |
頂端