This topic has not yet been rated - Rate this topic

CreateTriggerStatement Class

SQL Server 2012

Represents the CREATE TRIGGER statement.

System.Object
  Microsoft.SqlServer.TransactSql.ScriptDom.TSqlFragment
    Microsoft.SqlServer.TransactSql.ScriptDom.TSqlStatement
      Microsoft.SqlServer.TransactSql.ScriptDom.TriggerStatementBody
        Microsoft.SqlServer.TransactSql.ScriptDom.CreateTriggerStatement

Namespace: Microsoft.SqlServer.TransactSql.ScriptDom
Assembly: Microsoft.SqlServer.TransactSql.ScriptDom (in Microsoft.SqlServer.TransactSql.ScriptDom.dll)

Syntax

C++

JScript

public class CreateTriggerStatement extends TriggerStatementBody

The CreateTriggerStatement type exposes the following members.

Constructors

	Name	Description
	CreateTriggerStatement	Initializes a new instance of the CreateTriggerStatement class.

Top

Properties

	Name	Description
	FirstTokenIndex	Gets or sets the first token index. (Inherited from TSqlFragment.)
	FragmentLength	Gets the fragment length. (Inherited from TSqlFragment.)
	IsNotForReplication	Gets or sets a value that indicates whether NOT FOR REPLICATION is defined. (Inherited from TriggerStatementBody.)
	LastTokenIndex	Gets or sets the last token index. (Inherited from TSqlFragment.)
	MethodSpecifier	Gets or sets the name of the method specifier. (Inherited from TriggerStatementBody.)
	Name	Gets or sets the name of the trigger. It can at most be a two part name. (Inherited from TriggerStatementBody.)
	Options	Gets or sets the Options in WITH clause - different options for trigger and function (Inherited from TriggerStatementBody.)
	ScriptTokenStream	Gets or sets a list of token streams. (Inherited from TSqlFragment.)
	StartColumn	Gets the starting column. (Inherited from TSqlFragment.)
	StartLine	Gets the starting line. (Inherited from TSqlFragment.)
	StartOffset	Gets the fragment start offset value. (Inherited from TSqlFragment.)
	StatementList	Gets or sets the statements for trigger. (Inherited from TriggerStatementBody.)
	TriggerActions	Gets or sets the trigger actions. (Inherited from TriggerStatementBody.)
	TriggerObject	Gets or sets the target. (Inherited from TriggerStatementBody.)
	TriggerType	Gets or sets the type of the trigger. (Inherited from TriggerStatementBody.)
	WithAppend	Gets or sets a value that indicates whether WITH APPEND is defined. (Inherited from TriggerStatementBody.)

Top

Methods

	Name	Description
	Accept	Indicates the entry point for a given visitor. (Overrides TSqlFragment.Accept(TSqlFragmentVisitor).)
	AcceptChildren	Calls Accept on the children with the given visitor. (Overrides TriggerStatementBody.AcceptChildren(TSqlFragmentVisitor).)
	Equals	(Inherited from Object.)
	Finalize	(Inherited from Object.)
	GetHashCode	(Inherited from Object.)
	GetType	(Inherited from Object.)
	MemberwiseClone	(Inherited from Object.)
	ToString	(Inherited from Object.)

Top

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Reference

Microsoft.SqlServer.TransactSql.ScriptDom Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD