CreateOrAlterTriggerStatement Class

Reference

Definition

Namespace:: Microsoft.SqlServer.TransactSql.ScriptDom

Assembly:: Microsoft.SqlServer.TransactSql.ScriptDom.dll

Package:: Microsoft.SqlServer.DacFx.x64 v140.3881.1

Package:: Microsoft.SqlServer.DacFx v150.5282.3

Package:: Microsoft.SqlServer.DacFx v160.6161.0

Package:: Microsoft.Data.Tools.Msbuild v10.0.61804.210

Package:: Microsoft.SqlServer.TransactSql.ScriptDom v161.8901.0

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

The CREATE OR ALTER TRIGGER statement.

[System.Serializable]
public class CreateOrAlterTriggerStatement : Microsoft.SqlServer.TransactSql.ScriptDom.TriggerStatementBody

[<System.Serializable>]
type CreateOrAlterTriggerStatement = class
    inherit TriggerStatementBody

Public Class CreateOrAlterTriggerStatement
Inherits TriggerStatementBody

Inheritance: Object

TSqlFragment

TSqlStatement

TriggerStatementBody
CreateOrAlterTriggerStatement

Attributes: SerializableAttribute

Constructors

CreateOrAlterTriggerStatement()

Fields

Uninitialized

Constant to indicate and uninitialized token.

(Inherited from TSqlFragment)

Properties

FirstTokenIndex	Gets or sets the first index of the token. (Inherited from TSqlFragment)
FragmentLength	Defines the number of characters the fragment takes up in the script it was parsed. (Inherited from TSqlFragment)
IsNotForReplication	True if NOT FOR REPLICATION is defined. (Inherited from TriggerStatementBody)
LastTokenIndex	Gets or sets the last index of the token. (Inherited from TSqlFragment)
MethodSpecifier	The name of the method specifier. (Inherited from TriggerStatementBody)
Name	The name of the trigger. Can at most be a two part name. (Inherited from TriggerStatementBody)
Options	Options in WITH clause - different options for trigger and function (Inherited from TriggerStatementBody)
ScriptTokenStream	Gets or sets the script token stream. (Inherited from TSqlFragment)
StartColumn	Gets the start column. (Inherited from TSqlFragment)
StartLine	Gets the start line. (Inherited from TSqlFragment)
StartOffset	Defines the character offset of fragments starting location in the script it was parsed. (Inherited from TSqlFragment)
StatementList	Statements for trigger. (Inherited from TriggerStatementBody)
TriggerActions	The trigger actions. (Inherited from TriggerStatementBody)
TriggerObject	The target. (Inherited from TriggerStatementBody)
TriggerType	The type of the trigger. (Inherited from TriggerStatementBody)
WithAppend	True if WITH APPEND is defined. (Inherited from TriggerStatementBody)

Methods

Accept(TSqlFragmentVisitor)	Accepts visitor
AcceptChildren(TSqlFragmentVisitor)	Accepts visitor for Children

Applies to

Freigeben über