SQL Server

United States (English) Sign in

Print This Topic Print Multiple Topics

Home 2012 2008 R2 2008 Previous Versions Library Forums

TechNet Library

SQL Server

SQL Server 2012

Product Documentation

Developer Reference for SQL Server 2012

Developer Reference

Developer's Guide (Database Engine)

SQL Server Tool and UI Class Library

Microsoft.SqlServer.TransactSql.ScriptDom

AddAlterFullTextIndexAction Class

AddFileSpec Class

AddMemberAlterRoleAction Class

AddSearchPropertyListAction Class

AddSignatureStatement Class

AdHocDataSource Class

AdHocTableReference Class

AffinityKind Enumeration

AlgorithmKeyOption Class

AllowConnectionsOptionKind Enumeration

AlterAction Enumeration

AlterApplicationRoleStatement Class

AlterAssemblyStatement Class

AlterAsymmetricKeyStatement Class

AlterAuthorizationStatement Class

AlterAvailabilityGroupAction Class

AlterAvailabilityGroupActionType Enumeration

AlterAvailabilityGroupFailoverAction Class

AlterAvailabilityGroupFailoverOption Class

AlterAvailabilityGroupStatement Class

AlterAvailabilityGroupStatementType Enumeration

AlterBrokerPriorityStatement Class

AlterCertificateStatement Class

AlterCertificateStatementKind Enumeration

AlterColumnAlterFullTextIndexAction Class

AlterCreateEndpointStatementBase Class

AlterCreateServiceStatementBase Class

AlterCredentialStatement Class

AlterCryptographicProviderStatement Class

AlterDatabaseAddFileGroupStatement Class

AlterDatabaseAddFileStatement Class

AlterDatabaseAuditSpecificationStatement Class

AlterDatabaseCollateStatement Class

AlterDatabaseEncryptionKeyStatement Class

AlterDatabaseModifyFileGroupStatement Class

AlterDatabaseModifyFileStatement Class

AlterDatabaseModifyNameStatement Class

AlterDatabaseRebuildLogStatement Class

AlterDatabaseRemoveFileGroupStatement Class

AlterDatabaseRemoveFileStatement Class

AlterDatabaseSetStatement Class

AlterDatabaseStatement Class

AlterDatabaseTermination Class

AlterEndpointStatement Class

AlterEventSessionStatement Class

AlterEventSessionStatementType Enumeration

AlterFederationKind Enumeration

AlterFederationStatement Class

AlterFullTextCatalogAction Enumeration

AlterFullTextCatalogStatement Class

AlterFullTextIndexAction Class

AlterFullTextIndexStatement Class

AlterFullTextStopListStatement Class

AlterFunctionStatement Class

AlterIndexStatement Class

AlterIndexType Enumeration

AlterLoginAddDropCredentialStatement Class

AlterLoginEnableDisableStatement Class

AlterLoginOptionsStatement Class

AlterLoginStatement Class

AlterMasterKeyOption Enumeration

AlterMasterKeyStatement Class

AlterMessageTypeStatement Class

AlterPartitionFunctionStatement Class

AlterPartitionSchemeStatement Class

AlterProcedureStatement Class

AlterQueueStatement Class

AlterRemoteServiceBindingStatement Class

AlterResourceGovernorCommandType Enumeration

AlterResourceGovernorStatement Class

AlterResourcePoolStatement Class

AlterRoleAction Class

AlterRoleStatement Class

AlterRouteStatement Class

AlterSchemaStatement Class

AlterSearchPropertyListStatement Class

AlterSequenceStatement Class

AlterServerAuditSpecificationStatement Class

AlterServerAuditStatement Class

AlterServerConfigurationStatement Class

AlterServerRoleStatement Class

AlterServiceMasterKeyOption Enumeration

AlterServiceMasterKeyStatement Class

AlterServiceStatement Class

AlterSymmetricKeyStatement Class

AlterTableAddTableElementStatement Class

AlterTableAlterColumnOption Enumeration

AlterTableAlterColumnStatement Class

AlterTableChangeTrackingModificationStatement Class

AlterTableConstraintModificationStatement Class

AlterTableDropTableElement Class

AlterTableDropTableElementStatement Class

AlterTableFileTableNamespaceStatement Class

AlterTableRebuildStatement Class

AlterTableSetStatement Class

AlterTableStatement Class

AlterTableSwitchStatement Class

AlterTableTriggerModificationStatement Class

AlterTriggerStatement Class

AlterUserStatement Class

AlterViewStatement Class

AlterWorkloadGroupStatement Class

AlterXmlSchemaCollectionStatement Class

ApplicationRoleOption Class

ApplicationRoleOptionKind Enumeration

ApplicationRoleStatement Class

AssemblyEncryptionSource Class

AssemblyName Class

AssemblyOption Class

AssemblyOptionKind Enumeration

AssemblyStatement Class

AssignmentKind Enumeration

AssignmentSetClause Class

AsymmetricKeyCreateLoginSource Class

AttachMode Enumeration

AuditActionGroup Enumeration

AuditActionGroupReference Class

AuditActionSpecification Class

AuditFailureActionType Enumeration

AuditGuidAuditOption Class

AuditOption Class

AuditOptionKind Enumeration

AuditSpecificationDetail Class

AuditSpecificationPart Class

AuditSpecificationStatement Class

AuditTarget Class

AuditTargetKind Enumeration

AuditTargetOption Class

AuditTargetOptionKind Enumeration

AuthenticationEndpointProtocolOption Class

AuthenticationPayloadOption Class

AuthenticationProtocol Enumeration

AuthenticationTypes Enumeration

AutoCleanupChangeTrackingOptionDetail Class

AvailabilityGroupOption Class

AvailabilityGroupOptionKind Enumeration

AvailabilityGroupStatement Class

AvailabilityModeOptionKind Enumeration

AvailabilityModeReplicaOption Class

AvailabilityReplica Class

AvailabilityReplicaOption Class

AvailabilityReplicaOptionKind Enumeration

BackupCertificateStatement Class

BackupDatabaseStatement Class

BackupMasterKeyStatement Class

BackupOption Class

BackupOptionKind Enumeration

BackupRestoreFileInfo Class

BackupRestoreItemKind Enumeration

BackupRestoreMasterKeyStatementBase Class

BackupServiceMasterKeyStatement Class

BackupStatement Class

BackupTransactionLogStatement Class

BackwardsCompatibleDropIndexClause Class

BeginConversationTimerStatement Class

BeginDialogStatement Class

BeginEndBlockStatement Class

BeginTransactionStatement Class

BinaryExpression Class

BinaryExpressionType Enumeration

BinaryLiteral Class

BinaryQueryExpression Class

BinaryQueryExpressionType Enumeration

BooleanBinaryExpression Class

BooleanBinaryExpressionType Enumeration

BooleanComparisonExpression Class

BooleanComparisonType Enumeration

BooleanExpression Class

BooleanExpressionSnippet Class

BooleanIsNullExpression Class

BooleanNotExpression Class

BooleanParenthesisExpression Class

BooleanTernaryExpression Class

BooleanTernaryExpressionType Enumeration

BoundingBoxParameter Class

BoundingBoxParameterType Enumeration

BoundingBoxSpatialIndexOption Class

BreakStatement Class

BrokerPriorityParameter Class

BrokerPriorityParameterSpecialType Enumeration

BrokerPriorityParameterType Enumeration

BrokerPriorityStatement Class

BrowseForClause Class

BuiltInFunctionTableReference Class

BulkInsertBase Class

BulkInsertOption Class

BulkInsertOptionKind Enumeration

BulkInsertStatement Class

BulkOpenRowset Class

CallTarget Class

CaseExpression Class

CellsPerObjectSpatialIndexOption Class

CertificateCreateLoginSource Class

CertificateOption Class

CertificateOptionKinds Enumeration

CertificateStatementBase Class

ChangeRetentionChangeTrackingOptionDetail Class

ChangeTableChangesTableReference Class

ChangeTableVersionTableReference Class

ChangeTrackingDatabaseOption Class

ChangeTrackingFullTextIndexOption Class

ChangeTrackingOption Enumeration

ChangeTrackingOptionDetail Class

CharacterSetPayloadOption Class

CheckConstraintDefinition Class

CheckpointStatement Class

ChildObjectName Class

CloseCursorStatement Class

CloseMasterKeyStatement Class

CloseSymmetricKeyStatement Class

CoalesceExpression Class

ColumnDefinition Class

ColumnDefinitionBase Class

ColumnReferenceExpression Class

ColumnStorageOptions Class

ColumnType Enumeration

ColumnWithSortOrder Class

CommandOptions Enumeration

CommandSecurityElement80 Class

CommitTransactionStatement Class

CommonTableExpression Class

CompositeGroupingSpecification Class

CompressionEndpointProtocolOption Class

CompressionPartitionRange Class

ComputeClause Class

ComputeFunction Class

ComputeFunctionType Enumeration

ConstraintDefinition Class

ConstraintEnforcement Enumeration

ContainmentDatabaseOption Class

ContainmentOptionKind Enumeration

ContinueStatement Class

ContractMessage Class

ConvertCall Class

CreateAggregateStatement Class

CreateApplicationRoleStatement Class

CreateAssemblyStatement Class

CreateAsymmetricKeyStatement Class

CreateAvailabilityGroupStatement Class

CreateBrokerPriorityStatement Class

CreateCertificateStatement Class

CreateColumnStoreIndexStatement Class

CreateContractStatement Class

CreateCredentialStatement Class

CreateCryptographicProviderStatement Class

CreateDatabaseAuditSpecificationStatement Class

CreateDatabaseEncryptionKeyStatement Class

CreateDatabaseStatement Class

CreateDefaultStatement Class

CreateEndpointStatement Class

CreateEventNotificationStatement Class

CreateEventSessionStatement Class

CreateFederationStatement Class

CreateFullTextCatalogStatement Class

CreateFullTextIndexStatement Class

CreateFullTextStopListStatement Class

CreateFunctionStatement Class

CreateIndexStatement Class

CreateLoginSource Class

CreateLoginStatement Class

CreateMasterKeyStatement Class

CreateMessageTypeStatement Class

CreatePartitionFunctionStatement Class

CreatePartitionSchemeStatement Class

CreateProcedureStatement Class

CreateQueueStatement Class

CreateRemoteServiceBindingStatement Class

CreateResourcePoolStatement Class

CreateRoleStatement Class

CreateRouteStatement Class

CreateRuleStatement Class

CreateSchemaStatement Class

CreateSearchPropertyListStatement Class

CreateSelectiveXmlIndexStatement Class

CreateSequenceStatement Class

CreateServerAuditSpecificationStatement Class

CreateServerAuditStatement Class

CreateServerRoleStatement Class

CreateServiceStatement Class

CreateSpatialIndexStatement Class

CreateStatisticsStatement Class

CreateSymmetricKeyStatement Class

CreateSynonymStatement Class

CreateTableStatement Class

CreateTriggerStatement Class

CreateTypeStatement Class

CreateTypeTableStatement Class

CreateTypeUddtStatement Class

CreateTypeUdtStatement Class

CreateUserStatement Class

CreateViewStatement Class

CreateWorkloadGroupStatement Class

CreateXmlIndexStatement Class

CreateXmlSchemaCollectionStatement Class

CreationDispositionKeyOption Class

CredentialStatement Class

CryptoMechanism Class

CryptoMechanismType Enumeration

CubeGroupingSpecification Class

CursorDefaultDatabaseOption Class

CursorDefinition Class

CursorOption Class

CursorOptionKind Enumeration

CursorStatement Class

DatabaseAuditAction Class

DatabaseAuditActionKind Enumeration

DatabaseEncryptionKeyAlgorithm Enumeration

DatabaseEncryptionKeyStatement Class

DatabaseMirroringEndpointRole Enumeration

DatabaseOption Class

DatabaseOptionKind Enumeration

DataCompressionLevel Enumeration

DataCompressionOption Class

DataModificationSpecification Class

DataModificationStatement Class

DataModificationTableReference Class

DataTypeReference Class

DataTypeSequenceOption Class

DbccCommand Enumeration

DbccNamedLiteral Class

DbccOption Class

DbccOptionKind Enumeration

DbccStatement Class

DeallocateCursorStatement Class

DeclareCursorStatement Class

DeclareTableVariableBody Class

DeclareTableVariableStatement Class

DeclareVariableElement Class

DeclareVariableStatement Class

DefaultConstraintDefinition Class

DefaultLiteral Class

DeleteMergeAction Class

DeleteSpecification Class

DeleteStatement Class

DeleteUpdateAction Enumeration

DenyStatement Class

DenyStatement80 Class

DeviceInfo Class

DeviceType Enumeration

DialogOption Class

DialogOptionKind Enumeration

DiskStatement Class

DiskStatementOption Class

DiskStatementOptionKind Enumeration

DiskStatementType Enumeration

DropAggregateStatement Class

DropAlterFullTextIndexAction Class

DropApplicationRoleStatement Class

DropAssemblyStatement Class

DropAsymmetricKeyStatement Class

DropAvailabilityGroupStatement Class

DropBrokerPriorityStatement Class

DropCertificateStatement Class

DropChildObjectsStatement Class

DropClusteredConstraintMoveOption Class

DropClusteredConstraintOption Class

DropClusteredConstraintOptionKind Enumeration

DropClusteredConstraintStateOption Class

DropClusteredConstraintValueOption Class

DropContractStatement Class

DropCredentialStatement Class

DropCryptographicProviderStatement Class

DropDatabaseAuditSpecificationStatement Class

DropDatabaseEncryptionKeyStatement Class

DropDatabaseStatement Class

DropDefaultStatement Class

DropEndpointStatement Class

DropEventNotificationStatement Class

DropEventSessionStatement Class

DropFederationStatement Class

DropFullTextCatalogStatement Class

DropFullTextIndexStatement Class

DropFullTextStopListStatement Class

DropFunctionStatement Class

DropIndexClause Class

DropIndexClauseBase Class

DropIndexStatement Class

DropLoginStatement Class

DropMasterKeyStatement Class

DropMemberAlterRoleAction Class

DropMessageTypeStatement Class

DropObjectsStatement Class

DropPartitionFunctionStatement Class

DropPartitionSchemeStatement Class

DropProcedureStatement Class

DropQueueStatement Class

DropRemoteServiceBindingStatement Class

DropResourcePoolStatement Class

DropRoleStatement Class

DropRouteStatement Class

DropRuleStatement Class

DropSchemaBehavior Enumeration

DropSchemaStatement Class

DropSearchPropertyListAction Class

DropSearchPropertyListStatement Class

DropSequenceStatement Class

DropServerAuditSpecificationStatement Class

DropServerAuditStatement Class

DropServerRoleStatement Class

DropServiceStatement Class

DropSignatureStatement Class

DropStatisticsStatement Class

DropSymmetricKeyStatement Class

DropSynonymStatement Class

DropTableStatement Class

DropTriggerStatement Class

DropTypeStatement Class

DropUnownedObjectStatement Class

DropUserStatement Class

DropViewStatement Class

DropWorkloadGroupStatement Class

DropXmlSchemaCollectionStatement Class

EnabledDisabledPayloadOption Class

EnableDisableOptionType Enumeration

EnableDisableTriggerStatement Class

EncryptionAlgorithm Enumeration

EncryptionAlgorithmPreference Enumeration

EncryptionPayloadOption Class

EncryptionSource Class

EndConversationStatement Class

EndpointAffinity Class

EndpointEncryptionSupport Enumeration

EndpointProtocol Enumeration

EndpointProtocolOption Class

EndpointProtocolOptions Enumeration

EndpointState Enumeration

EndpointType Enumeration

EventDeclaration Class

EventDeclarationCompareFunctionParameter Class

EventDeclarationSetParameter Class

EventGroupContainer Class

EventNotificationEventGroup Enumeration

EventNotificationEventType Enumeration

EventNotificationObjectScope Class

EventNotificationTarget Enumeration

EventRetentionSessionOption Class

EventSessionEventRetentionModeType Enumeration

EventSessionMemoryPartitionModeType Enumeration

EventSessionObjectName Class

EventSessionStatement Class

EventTypeContainer Class

EventTypeGroupContainer Class

ExecutableEntity Class

ExecutableProcedureReference Class

ExecutableStringList Class

ExecuteAsClause Class

ExecuteAsFunctionOption Class

ExecuteAsOption Enumeration

ExecuteAsProcedureOption Class

ExecuteAsStatement Class

ExecuteAsTriggerOption Class

ExecuteContext Class

ExecuteInsertSource Class

ExecuteOption Class

ExecuteOptionKind Enumeration

ExecuteParameter Class

ExecuteSpecification Class

ExecuteStatement Class

ExistsPredicate Class

ExpressionCallTarget Class

ExpressionGroupingSpecification Class

ExpressionWithSortOrder Class

ExtractFromExpression Class

FailoverActionOptionKind Enumeration

FailoverModeOptionKind Enumeration

FailoverModeReplicaOption Class

FederationScheme Class

FetchCursorStatement Class

FetchOrientation Enumeration

FetchType Class

FileDeclaration Class

FileDeclarationOption Class

FileDeclarationOptionKind Enumeration

FileEncryptionSource Class

FileGroupDefinition Class

FileGroupOrPartitionScheme Class

FileGrowthFileDeclarationOption Class

FileNameFileDeclarationOption Class

FileStreamDatabaseOption Class

FileStreamOnDropIndexOption Class

FileStreamOnTableOption Class

FileStreamRestoreOption Class

FileTableCollateFileNameTableOption Class

FileTableConstraintNameTableOption Class

FileTableDirectoryTableOption Class

FipsComplianceLevel Enumeration

ForceSeekTableHint Class

ForClause Class

ForeignKeyConstraintDefinition Class

FromClause Class

FullTextCatalogAndFileGroup Class

FullTextCatalogOption Class

FullTextCatalogOptionKind Enumeration

FullTextCatalogStatement Class

FullTextFunctionType Enumeration

FullTextIndexColumn Class

FullTextIndexOption Class

FullTextIndexOptionKind Enumeration

FullTextPredicate Class

FullTextStopListAction Class

FullTextTableReference Class

FunctionCall Class

FunctionCallSetClause Class

FunctionOption Class

FunctionOptionKind Enumeration

FunctionReturnType Class

FunctionStatementBody Class

GeneralSetCommand Class

GeneralSetCommandType Enumeration

GetConversationGroupStatement Class

GlobalVariableExpression Class

GoToStatement Class

GrandTotalGroupingSpecification Class

GrantStatement Class

GrantStatement80 Class

GridParameter Class

GridParameterType Enumeration

GridsSpatialIndexOption Class

GroupByClause Class

GroupByOption Enumeration

GroupingSetsGroupingSpecification Class

GroupingSpecification Class

HadrAvailabilityGroupDatabaseOption Class

HadrDatabaseOption Class

HadrDatabaseOptionKind Enumeration

HavingClause Class

Identifier Class

IdentifierDatabaseOption Class

IdentifierLiteral Class

IdentifierOrValueExpression Class

IdentifierPrincipalOption Class

IdentifierSnippet Class

IdentityFunctionCall Class

IdentityOptions Class

IdentityValueKeyOption Class

IfStatement Class

IIfCall Class

ImportanceParameterType Enumeration

IndexExpressionOption Class

IndexOption Class

IndexOptionKind Enumeration

IndexStatement Class

IndexStateOption Class

IndexTableHint Class

InlineDerivedTable Class

InlineResultSetDefinition Class

InPredicate Class

InsertBulkColumnDefinition Class

InsertBulkStatement Class

InsertMergeAction Class

InsertOption Enumeration

InsertSource Class

InsertSpecification Class

InsertStatement Class

IntegerLiteral Class

InternalOpenRowset Class

IPv4 Class

IsolationLevel Enumeration

JoinHint Enumeration

JoinParenthesisTableReference Class

JoinTableReference Class

KeyOption Class

KeyOptionKind Enumeration

KeySourceKeyOption Class

KeywordCasing Enumeration

KillQueryNotificationSubscriptionStatement Class

KillStatement Class

KillStatsJobStatement Class

LabelStatement Class

LeftFunctionCall Class

LikePredicate Class

LineNoStatement Class

ListenerIPEndpointProtocolOption Class

Literal Class

LiteralAuditTargetOption Class

LiteralAvailabilityGroupOption Class

LiteralBulkInsertOption Class

LiteralDatabaseOption Class

LiteralEndpointProtocolOption Class

LiteralOptimizerHint Class

LiteralPayloadOption Class

LiteralPrincipalOption Class

LiteralRange Class

LiteralReplicaOption Class

LiteralSessionOption Class

LiteralStatisticsOption Class

LiteralTableHint Class

LiteralType Enumeration

LockEscalationMethod Enumeration

LockEscalationTableOption Class

LoginTypePayloadOption Class

MasterKeyStatement Class

MaxDispatchLatencySessionOption Class

MaxLiteral Class

MaxRolloverFilesAuditTargetOption Class

MaxSizeAuditTargetOption Class

MaxSizeDatabaseOption Class

MaxSizeFileDeclarationOption Class

MemoryPartitionSessionOption Class

MemoryUnit Enumeration

MergeAction Class

MergeActionClause Class

MergeCondition Enumeration

MergeSpecification Class

MergeStatement Class

MessageSender Enumeration

MessageTypeStatementBase Class

MessageValidationMethod Enumeration

MethodSpecifier Class

MirrorToClause Class

ModifyFileGroupOption Enumeration

MoneyLiteral Class

MoveConversationStatement Class

MoveRestoreOption Class

MoveToDropIndexOption Class

MultiPartIdentifier Class

MultiPartIdentifierCallTarget Class

NamedTableReference Class

NameFileDeclarationOption Class

NextValueForExpression Class

NonTransactedFileStreamAccess Enumeration

NullableConstraintDefinition Class

NullIfExpression Class

NullLiteral Class

NullNotNull Enumeration

NumericLiteral Class

OdbcConvertSpecification Class

OdbcFunctionCall Class

OdbcLiteral Class

OdbcLiteralType Enumeration

OdbcQualifiedJoinTableReference Class

OffsetClause Class

OnFailureAuditOption Class

OnOffAssemblyOption Class

OnOffAuditTargetOption Class

OnOffDatabaseOption Class

OnOffDialogOption Class

OnOffFullTextCatalogOption Class

OnOffPrincipalOption Class

OnOffRemoteServiceBindingOption Class

OnOffSessionOption Class

OpenCursorStatement Class

OpenMasterKeyStatement Class

OpenQueryTableReference Class

OpenRowsetTableReference Class

OpenSymmetricKeyStatement Class

OpenXmlTableReference Class

OptimizeForOptimizerHint Class

OptimizerHint Class

OptimizerHintKind Enumeration

OptionState Enumeration

OrderBulkInsertOption Class

OrderByClause Class

OutputClause Class

OutputIntoClause Class

OverClause Class

PageVerifyDatabaseOption Class

PageVerifyDatabaseOptionKind Enumeration

ParameterizationDatabaseOption Class

ParameterizedDataTypeReference Class

ParameterlessCall Class

ParameterlessCallType Enumeration

ParameterModifier Enumeration

ParameterStyle Enumeration

ParenthesisExpression Class

ParseCall Class

ParseError Class

PartitionFunctionCall Class

PartitionFunctionRange Enumeration

PartitionParameterType Class

PartitionSpecifier Class

PartnerDatabaseOption Class

PartnerDatabaseOptionKind Enumeration

PasswordAlterPrincipalOption Class

PasswordCreateLoginSource Class

PayloadOption Class

PayloadOptionKinds Enumeration

Permission Class

PermissionSetAssemblyOption Class

PermissionSetOption Enumeration

PivotedTableReference Class

PortsEndpointProtocolOption Class

PortTypes Enumeration

PredicateSetStatement Class

PrimaryExpression Class

PrimaryRoleReplicaOption Class

PrincipalOption Class

PrincipalOptionKind Enumeration

PrincipalType Enumeration

PrintStatement Class

Privilege80 Class

PrivilegeSecurityElement80 Class

PrivilegeType80 Enumeration

ProcedureOption Class

ProcedureOptionKind Enumeration

ProcedureParameter Class

ProcedureReference Class

ProcedureReferenceName Class

ProcedureStatementBody Class

ProcedureStatementBodyBase Class

ProcessAffinityRange Class

ProcessAffinityType Enumeration

ProviderEncryptionSource Class

ProviderKeyNameKeyOption Class

QualifiedJoin Class

QualifiedJoinType Enumeration

QueryDerivedTable Class

QueryExpression Class

QueryParenthesisExpression Class

QuerySpecification Class

QueueDelayAuditOption Class

QueueExecuteAsOption Class

QueueOption Class

QueueOptionKind Enumeration

QueueProcedureOption Class

QueueStatement Class

QueueStateOption Class

QueueValueOption Class

QuoteType Enumeration

RaiseErrorLegacyStatement Class

RaiseErrorOptions Enumeration

RaiseErrorStatement Class

ReadOnlyForClause Class

ReadTextStatement Class

RealLiteral Class

ReceiveStatement Class

ReconfigureStatement Class

RecoveryDatabaseOption Class

RecoveryDatabaseOptionKind Enumeration

RemoteServiceBindingOption Class

RemoteServiceBindingOptionKind Enumeration

RemoteServiceBindingStatementBase Class

RenameAlterRoleAction Class

ResourcePoolAffinitySpecification Class

ResourcePoolAffinityType Enumeration

ResourcePoolParameter Class

ResourcePoolParameterType Enumeration

ResourcePoolStatement Class

RestoreMasterKeyStatement Class

RestoreOption Class

RestoreOptionKind Enumeration

RestoreServiceMasterKeyStatement Class

RestoreStatement Class

RestoreStatementKind Enumeration

ResultColumnDefinition Class

ResultSetDefinition Class

ResultSetsExecuteOption Class

ResultSetsOptionKind Enumeration

ResultSetType Enumeration

ReturnStatement Class

RevertStatement Class

RevokeStatement Class

RevokeStatement80 Class

RightFunctionCall Class

RolePayloadOption Class

RoleStatement Class

RollbackTransactionStatement Class

RollupGroupingSpecification Class

RouteOption Class

RouteOptionKind Enumeration

RouteStatement Class

SaveTransactionStatement Class

ScalarExpression Class

ScalarExpressionDialogOption Class

ScalarExpressionRestoreOption Class

ScalarExpressionSequenceOption Class

ScalarExpressionSnippet Class

ScalarFunctionReturnType Class

ScalarSubquery Class

SchemaDeclarationItem Class

SchemaObjectFunctionTableReference Class

SchemaObjectName Class

SchemaObjectNameOrValueExpression Class

SchemaObjectNameSnippet Class

SchemaObjectResultSetDefinition Class

SchemaPayloadOption Class

SearchedCaseExpression Class

SearchedWhenClause Class

SearchPropertyListAction Class

SearchPropertyListFullTextIndexOption Class

SecondaryRoleReplicaOption Class

SecondaryXmlIndexType Enumeration

SecurityElement80 Class

SecurityObjectKind Enumeration

SecurityPrincipal Class

SecurityStatement Class

SecurityStatementBody80 Class

SecurityTargetObject Class

SecurityTargetObjectName Class

SecurityUserClause80 Class

SelectElement Class

SelectFunctionReturnType Class

SelectInsertSource Class

SelectiveXmlIndexPromotedPath Class

SelectScalarExpression Class

SelectSetVariable Class

SelectStarExpression Class

SelectStatement Class

SelectStatementSnippet Class

SemanticFunctionType Enumeration

SemanticTableReference Class

SendStatement Class

SeparatorType Enumeration

SequenceOption Class

SequenceOptionKind Enumeration

SequenceStatement Class

ServerAuditStatement Class

ServiceBrokerOption Enumeration

ServiceContract Class

SessionOption Class

SessionOptionKind Enumeration

SessionTimeoutPayloadOption Class

SetClause Class

SetCommand Class

SetCommandStatement Class

SetErrorLevelStatement Class

SetFipsFlaggerCommand Class

SetIdentityInsertStatement Class

SetOffsets Enumeration

SetOffsetsStatement Class

SetOnOffStatement Class

SetOptions Enumeration

SetRowCountStatement Class

SetSearchPropertyListAlterFullTextIndexAction Class

SetStatisticsOptions Enumeration

SetStatisticsStatement Class

SetStopListAlterFullTextIndexAction Class

SetTextSizeStatement Class

SetTransactionIsolationLevelStatement Class

SetUserStatement Class

SetVariableStatement Class

ShutdownStatement Class

SignableElementKind Enumeration

SignatureStatementBase Class

SimpleAlterFullTextIndexAction Class

SimpleAlterFullTextIndexActionKind Enumeration

SimpleCaseExpression Class

SimpleWhenClause Class

SizeFileDeclarationOption Class

SoapMethod Class

SoapMethodAction Enumeration

SoapMethodFormat Enumeration

SoapMethodSchemas Enumeration

SortOrder Enumeration

SourceDeclaration Class

SparseColumnOption Enumeration

SpatialIndexingSchemeType Enumeration

SpatialIndexOption Class

SpatialIndexRegularOption Class

Sql100ScriptGenerator Class

Sql110ScriptGenerator Class

Sql80ScriptGenerator Class

Sql90ScriptGenerator Class

SqlCommandIdentifier Class

SqlDataTypeOption Enumeration

SqlDataTypeReference Class

SqlScriptGenerator Class

SqlScriptGeneratorOptions Class

SqlVersion Enumeration

StateAuditOption Class

StatementList Class

StatementListSnippet Class

StatementWithCtesAndXmlNamespaces Class

StatisticsOption Class

StatisticsOptionKind Enumeration

StopListFullTextIndexOption Class

StopRestoreOption Class

StringLiteral Class

SubqueryComparisonPredicate Class

SubqueryComparisonPredicateType Enumeration

SymmetricKeyStatement Class

TableDataCompressionOption Class

TableDefinition Class

TableElementType Enumeration

TableHint Class

TableHintKind Enumeration

TableHintsOptimizerHint Class

TableOption Class

TableOptionKind Enumeration

TableReference Class

TableReferenceWithAlias Class

TableReferenceWithAliasAndColumns Class

TableSampleClause Class

TableSampleClauseOption Enumeration

TableValuedFunctionReturnType Class

TargetDeclaration Class

TargetRecoveryTimeDatabaseOption Class

TextModificationStatement Class

ThrowStatement Class

TimeUnit Enumeration

TopRowFilter Class

TransactionStatement Class

TriggerAction Class

TriggerActionType Enumeration

TriggerEnforcement Enumeration

TriggerObject Class

TriggerOption Class

TriggerOptionKind Enumeration

TriggerScope Enumeration

TriggerStatementBody Class

TriggerType Enumeration

TruncateTableStatement Class

TryCastCall Class

TryCatchStatement Class

TryConvertCall Class

TryParseCall Class

TSEqualCall Class

TSql100Parser Class

TSql110Parser Class

TSql80Parser Class

TSql90Parser Class

TSqlAuditEventGroupHelper Class

TSqlAuditEventTypeHelper Class

TSqlBatch Class

TSqlConcreteFragmentVisitor Class

TSqlFragment Class

TSqlFragmentSnippet Class

TSqlFragmentVisitor Class

TSqlParser Class

TSqlParserToken Class

TSqlScript Class

TSqlStatement Class

TSqlStatementSnippet Class

TSqlTokenType Enumeration

TSqlTriggerEventGroupHelper Class

TSqlTriggerEventTypeHelper Class

UnaryExpression Class

UnaryExpressionType Enumeration

UniqueConstraintDefinition Class

UniqueRowFilter Enumeration

UnpivotedTableReference Class

UnqualifiedJoin Class

UnqualifiedJoinType Enumeration

UpdateCall Class

UpdateDeleteSpecificationBase Class

UpdateForClause Class

UpdateMergeAction Class

UpdateSpecification Class

UpdateStatement Class

UpdateStatisticsStatement Class

UpdateTextStatement Class

UseFederationStatement Class

UserDataTypeReference Class

UserDefinedTypeCallTarget Class

UserDefinedTypePropertyAccess Class

UserLoginOption Class

UserLoginOptionType Enumeration

UserRemoteServiceBindingOption Class

UserStatement Class

UserType80 Enumeration

UseStatement Class

ValueExpression Class

ValuesInsertSource Class

VariableMethodCallTableReference Class

VariableReference Class

VariableTableReference Class

VariableValuePair Class

ViewOption Class

ViewOptionKind Enumeration

ViewStatementBody Class

WaitForOption Enumeration

WaitForStatement Class

WaitForSupportedStatement Class

WhenClause Class

WhereClause Class

WhileStatement Class

WindowDelimiter Class

WindowDelimiterType Enumeration

WindowFrameClause Class

WindowFrameType Enumeration

WindowsCreateLoginSource Class

WithCtesAndXmlNamespaces Class

WithinGroupClause Class

WitnessDatabaseOption Class

WorkloadGroupImportanceParameter Class

WorkloadGroupParameter Class

WorkloadGroupParameterType Enumeration

WorkloadGroupResourceParameter Class

WorkloadGroupStatement Class

WriteTextStatement Class

WsdlPayloadOption Class

XmlDataTypeOption Enumeration

XmlDataTypeReference Class

XmlForClause Class

XmlForClauseOption Class

XmlForClauseOptions Enumeration

XmlNamespaces Class

XmlNamespacesAliasElement Class

XmlNamespacesDefaultElement Class

XmlNamespacesElement Class

Minimize

This topic has not yet been rated - Rate this topic

TriggerActionType Enumeration

SQL Server 2012

Specifies which data modification statements, when attempted against this table or view, activate the trigger.

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

[SerializableAttribute]
public enum TriggerActionType

	Member name	Description
	Delete	Type is Delete.
	Event	Type is Event.
	Insert	Type is Insert.
	LogOn	Type is LogOn.
	Update	Type is Update.

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

© 2013 Microsoft

Manage Your Profile

|

Site Feedback

© 2013 Microsoft. All rights reserved.