TriggerStatementBody TriggerStatementBody TriggerStatementBody Class


Represents CREATE/ALTER TRIGGER statement.

public abstract class TriggerStatementBody : Microsoft.SqlServer.TransactSql.ScriptDom.TSqlStatement
type TriggerStatementBody = class
    inherit TSqlStatement
Public MustInherit Class TriggerStatementBody
Inherits TSqlStatement


TriggerStatementBody() TriggerStatementBody() TriggerStatementBody()


FirstTokenIndex FirstTokenIndex FirstTokenIndex

Gets or sets the first index of the token.

(Inherited from TSqlFragment)
FragmentLength FragmentLength FragmentLength

Defines the number of characters the fragment takes up in the script it was parsed.

(Inherited from TSqlFragment)
IsNotForReplication IsNotForReplication IsNotForReplication

True if NOT FOR REPLICATION is defined.

LastTokenIndex LastTokenIndex LastTokenIndex

Gets or sets the last index of the token.

(Inherited from TSqlFragment)
MethodSpecifier MethodSpecifier MethodSpecifier

The name of the method specifier.

Name Name Name

The name of the trigger. Can at most be a two part name.

Options Options Options

Options in WITH clause - different options for trigger and function

ScriptTokenStream ScriptTokenStream ScriptTokenStream

Gets or sets the script token stream.

(Inherited from TSqlFragment)
StartColumn StartColumn StartColumn

Gets the start column.

(Inherited from TSqlFragment)
StartLine StartLine StartLine

Gets the start line.

(Inherited from TSqlFragment)
StartOffset StartOffset StartOffset

Defines the character offset of fragments starting location in the script it was parsed.

(Inherited from TSqlFragment)
StatementList StatementList StatementList

Statements for trigger.

TriggerActions TriggerActions TriggerActions

The trigger actions.

TriggerObject TriggerObject TriggerObject

The target.

TriggerType TriggerType TriggerType

The type of the trigger.

WithAppend WithAppend WithAppend

True if WITH APPEND is defined.


Accept(TSqlFragmentVisitor) Accept(TSqlFragmentVisitor) Accept(TSqlFragmentVisitor)

Accepts the specified visitor.

(Inherited from TSqlFragment)
AcceptChildren(TSqlFragmentVisitor) AcceptChildren(TSqlFragmentVisitor) AcceptChildren(TSqlFragmentVisitor)

Accepts visitor for Children


Uninitialized Uninitialized Uninitialized

Constant to indicate and uninitialized token.

(Inherited from TSqlFragment)

Applies to