Membros Trigger
The Trigger object represents a SQL Server trigger.
O tipo Trigger expõe os seguintes membros.
Construtores
| Nome | Descrição | |
|---|---|---|
.gif "Método público") |
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. |
Início
Métodos
| Nome | Descrição | |
|---|---|---|
.gif "Método protegido") |
AddDatabaseContext | (Herdado de SqlSmoObject.) |
|
Alter | Updates any Trigger object property changes on instance of Microsoft SQL Server . |
|
AlterImpl | (Herdado de SqlSmoObject.) |
|
AlterImplFinish | (Herdado de SqlSmoObject.) |
|
AlterImplInit | (Herdado de SqlSmoObject.) |
|
AlterImplWorker | (Herdado de SqlSmoObject.) |
|
AppendCommaText | (Herdado de ScriptNameObjectBase.) |
|
AppendWithCommaText | (Herdado de ScriptNameObjectBase.) |
|
AppendWithOption | (Herdado de ScriptNameObjectBase.) |
|
BindDefaultImpl | (Herdado de SqlSmoObject.) |
|
BindRuleImpl | (Herdado de SqlSmoObject.) |
|
CheckCollation | (Herdado de SqlSmoObject.) |
|
CheckObjectDirty | (Herdado de ScriptNameObjectBase.) |
|
CheckObjectState() () () () | Validates the state of the referenced object. (Herdado de SqlSmoObject.) |
|
CheckObjectState(Boolean) | Validates the state of the referenced object with the option to specify that an exception is thrown if the object is not yet created. (Herdado de SqlSmoObject.) |
|
CheckObjectStateImpl | (Herdado de SqlSmoObject.) |
|
CheckTextCorectness | (Herdado de ScriptNameObjectBase.) |
|
CheckTextModeSupport | (Herdado de ScriptNameObjectBase.) |
|
CheckVersion100 | (Herdado de SqlSmoObject.) |
|
CheckVersion80 | Checks the validity of the object on SQL Server 2000. (Herdado de SqlSmoObject.) |
|
CheckVersion80SP3 | Checks the validity of the object on SQL Server 2000 SP3. (Herdado de SqlSmoObject.) |
|
CheckVersion90 | Check the validity of the object on SQL Server 2005. (Herdado de SqlSmoObject.) |
|
CheckVersionBelow90 | (Herdado de SqlSmoObject.) |
|
CleanObject | Cleans the referenced object. (Herdado de ScriptNameObjectBase.) |
|
Create | Creates a trigger on the instance of SQL Server as defined by the Trigger object. |
|
CreateImpl | (Herdado de SqlSmoObject.) |
|
CreateImplFinish | (Herdado de SqlSmoObject.) |
|
CreateImplInit | (Herdado de SqlSmoObject.) |
|
Discover | (Herdado de SqlSmoObject.) |
|
Drop | Removes the trigger from the instance of SQL Server . |
|
DropImpl | (Herdado de SqlSmoObject.) |
|
DropImplWorker | (Herdado de SqlSmoObject.) |
|
EnumScriptImpl | (Herdado de SqlSmoObject.) |
|
EnumScriptImplWorker | (Herdado de SqlSmoObject.) |
|
Equals | (Herdado de Object.) |
|
Finalize | (Herdado de Object.) |
|
ForceTextModeOnTextBody | Enforces text mode on the text body. (Herdado de ScriptNameObjectBase.) |
|
FormatSqlVariant | (Herdado de SqlSmoObject.) |
|
GenerateDataSpaceFileStreamScript | (Herdado de SqlSmoObject.) |
|
GenerateDataSpaceScript | (Herdado de SqlSmoObject.) |
|
GetBindDefaultScript | (Herdado de SqlSmoObject.) |
|
GetBindRuleScript | (Herdado de SqlSmoObject.) |
|
GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%) | (Herdado de SqlSmoObject.) |
|
GetBoolParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) | (Herdado de SqlSmoObject.) |
|
GetBraketNameForText | (Herdado de ScriptNameObjectBase.) |
|
GetDateTimeParameter | (Herdado de SqlSmoObject.) |
|
GetDateTimeParameterAsInt | (Herdado de SqlSmoObject.) |
|
GetDBName | Gets the database name that is associated with the object. (Herdado de SqlSmoObject.) |
|
GetEnumParameter | (Herdado de SqlSmoObject.) |
|
GetFragOptionString | (Herdado de SqlSmoObject.) |
|
GetGuidParameter | (Herdado de SqlSmoObject.) |
|
GetHashCode | (Herdado de Object.) |
|
GetIsTextDirty | Determines whether the text value is consistent with stored value. (Herdado de ScriptNameObjectBase.) |
|
GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%) | (Herdado de SqlSmoObject.) |
|
GetParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) | (Herdado de SqlSmoObject.) |
|
GetPropValue | (Herdado de SqlSmoObject.) |
|
GetPropValueOptional | (Herdado de SqlSmoObject.) |
|
GetPropValueOptionalAllowNull | (Herdado de SqlSmoObject.) |
|
GetRealValue | (Herdado de SqlSmoObject.) |
|
GetScriptIncludeExists | (Herdado de ScriptNameObjectBase.) |
|
GetScriptingOptionsForCreate | (Herdado de SqlSmoObject.) |
|
GetServerName | Gets the name of the instance of SQL Server with which the object is associated. (Herdado de SqlSmoObject.) |
|
GetServerObject | (Herdado de SqlSmoObject.) |
|
GetSqlServerVersionName | Gets the version name of the instance of SQL Server with which the object is associated. (Herdado de SqlSmoObject.) |
|
GetStringParameter(StringBuilder, ScriptingOptions, String, String, Int32%) | (Herdado de SqlSmoObject.) |
|
GetStringParameter(StringBuilder, ScriptingOptions, String, String, Int32%, Boolean) | (Herdado de SqlSmoObject.) |
|
GetTextBody() () () () | Returns the text body. (Herdado de ScriptNameObjectBase.) |
|
GetTextBody(Boolean) | Returns the text body. (Herdado de ScriptNameObjectBase.) |
|
GetTextForScript(ScriptingOptions, Boolean, array<String> [] () [] []) | Gets the text for scripting. (Herdado de ScriptNameObjectBase.) |
|
GetTextForScript(ScriptingOptions, Boolean, array<String> [] () [] [], Boolean) | (Herdado de ScriptNameObjectBase.) |
|
GetTextHeader | Returns the text header. (Herdado de ScriptNameObjectBase.) |
|
GetTextMode | Determines whether the script name is using text mode. (Herdado de ScriptNameObjectBase.) |
|
GetTextProperty(String) | (Herdado de ScriptNameObjectBase.) |
|
GetTextProperty(String, ScriptingOptions) | (Herdado de ScriptNameObjectBase.) |
|
GetTimeSpanParameterAsInt | (Herdado de SqlSmoObject.) |
|
GetType | (Herdado de Object.) |
|
GetUrnRecursive(StringBuilder) | (Herdado de SqlSmoObject.) |
|
GetUrnRecursive(StringBuilder, UrnIdOption) | (Herdado de SqlSmoObject.) |
|
ImplInitialize | (Herdado de SqlSmoObject.) |
|
Initialize() () () () | Initializes the object and forces the properties be loaded. (Herdado de SqlSmoObject.) |
|
Initialize(Boolean) | Initializes the object and forces the properties be loaded. (Herdado de SqlSmoObject.) |
|
IsObjectDirty | Determines whether the referenced object is consistent with the stored object. (Herdado de ScriptNameObjectBase.) |
|
IsObjectInitialized | Verifies whether the object has been initialized. (Herdado de SqlSmoObject.) |
|
IsObjectInSpace | Verifies whether the object is isolated or connected to the instance of SQL Server. (Herdado de SqlSmoObject.) |
|
IsVersion80SP3 | (Herdado de SqlSmoObject.) |
|
MarkDropped | (Herdado de SqlSmoObject.) |
|
MarkForDrop | Marks the trigger to be dropped. |
|
MarkForDropImpl | (Herdado de SqlSmoObject.) |
|
MemberwiseClone | (Herdado de Object.) |
|
PostAlter | (Herdado de SqlSmoObject.) |
|
PostCreate | (Herdado de SqlSmoObject.) |
|
PostDrop | (Herdado de SqlSmoObject.) |
|
ReCompileReferences | |
|
Refresh | Refreshes the script name. (Herdado de ScriptNameObjectBase.) |
|
RenameImpl | This method supports the SMO infrastructure and is not intended to be used directly from your code. (Herdado de NamedSmoObject.) |
|
RenameImplWorker | This method supports the SMO infrastructure and is not intended to be used directly from your code. (Herdado de NamedSmoObject.) |
|
Script() () () () | Generates a Transact-SQL script that can be used to re-create the trigger. |
|
Script(ScriptingOptions) | Generates a Transact-SQL script that can be used to re-create the trigger as specified by the script options. |
|
ScriptAlter | (Herdado de SqlSmoObject.) |
|
ScriptAnsiQI | (Herdado de ScriptNameObjectBase.) |
|
ScriptChangeOwner | This method supports the SMO infrastructure and is not intended to be used directly from your code. (Herdado de NamedSmoObject.) |
|
ScriptCreate | (Herdado de SqlSmoObject.) |
|
ScriptDdl | (Herdado de SqlSmoObject.) |
|
ScriptDrop | (Herdado de SqlSmoObject.) |
|
ScriptHeader | Returns the text header with the option to modify the text. |
|
ScriptImpl() () () () | (Herdado de SqlSmoObject.) |
|
ScriptImpl(ScriptingOptions) | (Herdado de SqlSmoObject.) |
|
ScriptImplWorker | (Herdado de SqlSmoObject.) |
|
ScriptInformativeHeaders | (Herdado de ScriptNameObjectBase.) |
|
ScriptRename | This method supports the SMO infrastructure and is not intended to be used directly from your code. (Herdado de NamedSmoObject.) |
|
SetCollectionTextMode | Sets the collection text mode. (Herdado de ScriptNameObjectBase.) |
|
SetParentImpl | (Herdado de SqlSmoObject.) |
|
SetTextBody | Specifies the text body. (Herdado de ScriptNameObjectBase.) |
|
SetTextHeader | Specifies the text header. (Herdado de ScriptNameObjectBase.) |
|
SetTextMode | Specifies the text mode. (Herdado de ScriptNameObjectBase.) |
|
SwitchTextMode | Switches the text mode. (Herdado de ScriptNameObjectBase.) |
|
ThrowIfTextIsDirtyForAlter | (Herdado de ScriptNameObjectBase.) |
|
ToString | Returns a String that represents the referenced object. (Herdado de SqlSmoObject.) |
|
TouchImpl | (Herdado de SqlSmoObject.) |
|
UnbindDefaultImpl | (Herdado de SqlSmoObject.) |
|
UnbindRuleImpl | (Herdado de SqlSmoObject.) |
|
Validate | (Herdado de SmoObjectBase.) |
Início
.gif "Campo protegido")
Propriedades
| Nome | Descrição | |
|---|---|---|
.gif "Propriedade pública") |
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 "Propriedade protegida") |
ExecuteForScalar | Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (Herdado de 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. (Herdado de SqlSmoObject.) |
|
MethodName | Gets the method name for the trigger. |
|
Name | Gets or sets the name of the object. (Herdado de 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. (Herdado de 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. (Herdado de 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. (Herdado de SqlSmoObject.) |
|
State | Gets the state of the referenced object. (Herdado de 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. (Herdado de SqlSmoObject.) |
|
UserData | Gets or sets user-defined data associated with the referenced object. (Herdado de SmoObjectBase.) |
Início
Eventos
| Nome | Descrição | |
|---|---|---|
.gif "Evento público") |
PropertyChanged | (Herdado de SqlSmoObject.) |
|
PropertyMetadataChanged | (Herdado de SqlSmoObject.) |
Início
Implementações de interface explícitas
| Nome | Descrição | |
|---|---|---|
.gif "Implementação de interface explícita") .gif "Método particular") |
IAlienObjectDiscover | (Herdado de SqlSmoObject.) |
|
IAlienObjectGetParent | (Herdado de SqlSmoObject.) |
|
IAlienObjectGetProperty | (Herdado de SqlSmoObject.) |
|
ISfcPropertyProviderGetPropertySet | (Herdado de SqlSmoObject.) |
|
IAlienObjectGetUrn | (Herdado de SqlSmoObject.) |
|
IAlienObjectResolve | (Herdado de SqlSmoObject.) |
|
IAlienObjectSetProperty | (Herdado de SqlSmoObject.) |
Início