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 Management Objects

SQL Server Management Objects Reference

Microsoft.SqlServer.Management.Smo

AbstractCollectionBase Class

ActivationExecutionContext Enumeration

AffinityInfo Class

AffinityInfoBase Class

AffinityType Enumeration

ApplicationRole Class

ApplicationRoleCollection Class

ApplicationRoleEvents Class

ArrayListCollectionBase Class

AssemblyAlterOptions Enumeration

AssemblySecurityLevel Enumeration

AsymmetricKey Class

AsymmetricKeyCollection Class

AsymmetricKeyEncryptionAlgorithm Enumeration

AsymmetricKeySourceType Enumeration

AsyncStatus Class

AttachOptions Enumeration

Audit Class

AuditActionType Enumeration

AuditCollection Class

AuditDestinationType Enumeration

AuditExtender Class

AuditFileSizeUnit Enumeration

AuditLevel Enumeration

AuditSpecification Class

AuditSpecificationDetail Structure

AuditStatusType Enumeration

AuthenticationType Enumeration

AvailabilityDatabase Class

AvailabilityDatabaseCollection Class

AvailabilityDatabaseSynchronizationState Enumeration

AvailabilityGroup Class

AvailabilityGroupAutomatedBackupPreference Enumeration

AvailabilityGroupCollection Class

AvailabilityGroupFailureConditionLevel Enumeration

AvailabilityGroupListener Class

AvailabilityGroupListenerCollection Class

AvailabilityGroupListenerIPAddress Class

AvailabilityGroupListenerIPAddressCollection Class

AvailabilityGroupListenerIPAddressCollectionBase Class

AvailabilityGroupListenerIPState Enumeration

AvailabilityGroupRollupSynchronizationState Enumeration

AvailabilityGroupState Class

AvailabilityReplica Class

AvailabilityReplicaAvailabilityMode Enumeration

AvailabilityReplicaCollection Class

AvailabilityReplicaConnectionModeInPrimaryRole Enumeration

AvailabilityReplicaConnectionModeInSecondaryRole Enumeration

AvailabilityReplicaConnectionState Enumeration

AvailabilityReplicaFailoverMode Enumeration

AvailabilityReplicaJoinState Enumeration

AvailabilityReplicaOperationalState Enumeration

AvailabilityReplicaRole Enumeration

AvailabilityReplicaRollupRecoveryState Enumeration

AvailabilityReplicaRollupSynchronizationState Enumeration

Backup Class

BackupActionType Enumeration

BackupCompressionOptions Enumeration

BackupDevice Class

BackupDeviceCollection Class

BackupDeviceItem Class

BackupDeviceList Class

BackupDeviceType Enumeration

BackupMedia Class

BackupMediaSet Class

BackupMediaSet.IncompleteBackupMediaSetException Class

BackupRestoreBase Class

BackupRestoreBase.AsyncOperation Enumeration

BackupSet Class

BackupSetCollection Class

BackupSetFlag Enumeration

BackupSetType Enumeration

BackupTruncateLogType Enumeration

CatalogPopulationAction Enumeration

CatalogPopulationStatus Enumeration

Certificate Class

CertificateCollection Class

CertificateEvents Class

CertificateSourceType Enumeration

ChangeTracking Enumeration

Check Class

CheckCollection Class

ClusterMemberState Enumeration

ClusterMemberType Enumeration

ClusterQuorumState Enumeration

ClusterQuorumType Enumeration

CollationVersion Enumeration

CollectionNotAvailableException Class

Column Class

ColumnCollection Class

CompatibilityLevel Enumeration

ConfigProperty Class

ConfigPropertyCollection Class

Configuration Class

ConfigurationBase Class

ContainmentType Enumeration

Cpu Class

CpuCollection Class

CreateDispositionType Enumeration

Credential Class

CredentialCollection Class

CryptographicProvider Class

CryptographicProviderCollection Class

DatabaseActiveDirectory Class

DatabaseAdapter Class

DatabaseAdapterBase Class

DatabaseAuditSpecification Class

DatabaseAuditSpecificationCollection Class

DatabaseAuditSpecificationExtender Class

DatabaseCollection Class

DatabaseDdlTrigger Class

DatabaseDdlTriggerCollection Class

DatabaseDdlTriggerEvent Class

DatabaseDdlTriggerEventSet Class

DatabaseDdlTriggerExecutionContext Enumeration

DatabaseEncryptionAlgorithm Enumeration

DatabaseEncryptionKey Class

DatabaseEncryptionKeyExtender Class

DatabaseEncryptionState Enumeration

DatabaseEncryptionType Enumeration

DatabaseEvent Class

DatabaseEventArgs Class

DatabaseEvents Class

DatabaseEventSet Class

DatabaseEventType Enumeration

DatabaseFile Class

DatabaseFileMappingsDictionary Class

DatabaseMaintenanceAdapter Class

DatabaseMapping Class

DatabaseMirroringPayload Class

DatabaseObjectTypes Enumeration

DatabaseOptions Class

DatabasePerformanceAdapter Class

DatabasePermission Class

DatabasePermissionInfo Class

DatabasePermissionSet Class

DatabasePermissionSetValue Enumeration

DatabaseRecoveryState Enumeration

DatabaseReplicaState Class

DatabaseReplicaStateCollection Class

DatabaseReplicaStateCollectionBase Class

DatabaseReplicaSuspendReason Enumeration

DatabaseRestorePlanner Class

DatabaseRole Class

DatabaseRoleCollection Class

DatabaseSecurityAdapter Class

DatabaseSnapshotExtender Class

DatabaseStatus Enumeration

DatabaseUserAccess Enumeration

DataCompressionType Enumeration

DataFileCollection Class

DataTransferBase Class

DdlTextParserHeaderInfo Structure

DdlTriggerBase Class

Default Class

DefaultCollection Class

DefaultConstraint Class

DefaultLanguage Class

DefaultRuleBase Class

DependencyCollection Class

DependencyCollectionNode Class

DependencyNode Class

DependencyTree Class

DependencyTreeNode Class

DependencyType Enumeration

DependencyWalker Class

DeviceType Enumeration

DistributionType Enumeration

Edition Enumeration

EndpointAuthenticationOrder Enumeration

EndpointCollection Class

EndpointEncryption Enumeration

EndpointEncryptionAlgorithm Enumeration

EndpointPayload Class

EndpointProtocol Class

EndpointState Enumeration

EndpointType Enumeration

EventProperty Class

EventPropertyCollection Class

EventSetBase Class

EventType Enumeration

ExecutionContext Enumeration

ExecutionStatus Enumeration

ExtendedProperty Class

ExtendedPropertyCollection Class

ExtendedStoredProcedure Class

ExtendedStoredProcedureCollection Class

FailedOperationException Class

Federation Class

FederationCollection Class

FileGroup Class

FileGroupCollection Class

FileGrowthType Enumeration

FilestreamAccessLevelType Enumeration

FileStreamEffectiveLevel Enumeration

FileStreamLevel Enumeration

FilestreamNonTransactedAccessType Enumeration

ForeignKey Class

ForeignKeyAction Enumeration

ForeignKeyCollection Class

ForeignKeyColumn Class

ForeignKeyColumnCollection Class

FragmentationOption Enumeration

FrequencyPair Class

FullTextCatalog Class

FullTextCatalogCollection Class

FullTextCatalogUpgradeOption Enumeration

FullTextIndex Class

FullTextIndexColumn Class

FullTextIndexColumnCollection Class

FullTextService Class

FullTextStopList Class

FullTextStopListCollection Class

HadrManagerStatus Enumeration

HttpAuthenticationModes Enumeration

HttpPortTypes Enumeration

HttpProtocol Class

IAvailabilityGroupState Interface

IColumnPermission Interface

IDatabaseMaintenanceFacet Interface

IDatabaseOptions Interface

IDatabasePerformanceFacet Interface

IDatabaseSecurityFacet Interface

IExtendedProperties Interface

ILoginOptions Interface

ImplementationType Enumeration

IMultipartNameFacet Interface

INameFacet Interface

Index Class

IndexCollection Class

IndexedColumn Class

IndexedColumnCollection Class

IndexedXmlPath Class

IndexedXmlPathCollection Class

IndexedXmlPathNamespace Class

IndexedXmlPathNamespaceCollection Class

IndexedXmlPathType Enumeration

IndexEnableAction Enumeration

IndexEvents Class

IndexKeyType Enumeration

IndexOperation Enumeration

IndexPopulationAction Enumeration

IndexPopulationStatus Enumeration

IndexType Enumeration

InDoubtTransactionResolutionType Enumeration

Information Class

InstanceState Enumeration

InternalSmoErrorException Class

InvalidRestorePlanException Class

InvalidScriptingOptionException Class

InvalidSmoOperationException Class

InvalidVersionSmoOperationException Class

IObjectPermission Interface

IScriptable Interface

IServerAuditFacet Interface

IServerConfigurationFacet Interface

IServerInformation Interface

IServerPerformanceFacet Interface

IServerSecurityFacet Interface

IServerSelectionFacet Interface

IServerSettings Interface

IServerSetupFacet Interface

ISurfaceAreaFacet Interface

ITableOptions Interface

ITextObject Interface

IUserOptions Interface

IViewOptions Interface

JobScheduleCollectionBase Class

KeyEncryptionType Enumeration

LanguageCollection Class

LinkedServer Class

LinkedServerCollection Class

LinkedServerLogin Class

LinkedServerLoginCollection Class

LinkedTableType Enumeration

LinkFieldType Enumeration

LockEscalationType Enumeration

LockRequestStatus Enumeration

LogFile Class

LogFileCollection Class

Login Class

LoginCollection Class

LoginCreateOptions Enumeration

LoginEvents Class

LoginType Enumeration

LogReuseWaitStatus Enumeration

MappedClassType Enumeration

MasterKey Class

MediaTypes Enumeration

MessageCollectionBase Class

MessageObjectBase Class

MethodLoginType Enumeration

MethodXsdSchemaOption Enumeration

MirroringOption Enumeration

MirroringRole Enumeration

MirroringSafetyLevel Enumeration

MirroringStatus Enumeration

MirroringWitnessStatus Enumeration

MissingObjectException Class

Month Enumeration

NamedSmoObject Class

NextRestoreEventArgs Class

NextRestoreEventHandler Delegate

NSActivationState Enumeration

NumaNodeAffinity Enumeration

NumaNodeCollection Class

NumberedObjectCollectionBase Class

NumberedStoredProcedure Class

NumberedStoredProcedureCollection Class

NumberedStoredProcedureParameter Class

NumberedStoredProcedureParameterCollection Class

ObjectAlteredEventArgs Class

ObjectClass Enumeration

ObjectCreatedEventArgs Class

ObjectDroppedEventArgs Class

ObjectEvent Class

ObjectEventSet Class

ObjectPermission Class

ObjectPermissionInfo Class

ObjectPermissionSet Class

ObjectPermissionSetValue Enumeration

ObjectRenamedEventArgs Class

OleDbProviderSettings Class

OleDbProviderSettingsCollection Class

OnFailureAction Enumeration

OrderColumn Class

OrderColumnCollection Class

PageRestorePlanner Class

PageVerify Enumeration

Parameter Class

ParameterBase Class

ParameterCollectionBase Class

PartitionFunction Class

PartitionFunctionCollection Class

PartitionFunctionEvents Class

PartitionFunctionParameter Class

PartitionFunctionParameterCollection Class

PartitionNumberedObjectCollectionBase Class

PartitionScheme Class

PartitionSchemeCollection Class

PartitionSchemeEvents Class

PartitionSchemeParameter Class

PartitionSchemeParameterCollection Class

PasswordHashAlgorithm Enumeration

Payload Class

PercentCompleteEventArgs Class

PercentCompleteEventHandler Delegate

PerfMonMode Enumeration

PerformanceCounters Class

PermissionInfo Class

PermissionSetBase Class

PermissionState Enumeration

PhysicalPartition Class

PhysicalPartitionCollection Class

PlanGuide Class

PlanGuideCollection Class

PlanGuideExtender Class

PlanGuideType Enumeration

PrincipalType Enumeration

PrivateKeyEncryptionType Enumeration

PrivilegeTypes Enumeration

ProgressReportEventArgs Class

ProgressReportEventHandler Delegate

PropertyCannotBeRetrievedException Class

PropertyCollection Class

PropertyNotSetException Class

PropertyReadOnlyException Class

PropertyTypeMismatchException Class

PropertyWriteException Class

ProtocolType Enumeration

ProviderAuthenticationType Enumeration

RangeType Enumeration

RecoveryModel Enumeration

RelocateFile Class

RepairOptions Enumeration

RepairStructure Enumeration

RepairType Enumeration

ReplicationOptions Enumeration

ResourceGovernor Class

ResourcePool Class

ResourcePoolAffinityInfo Class

ResourcePoolCollection Class

ResourceUsage Enumeration

Restore Class

RestoreActionType Enumeration

RestoreOptions Class

RestorePlan Class

RestoreType Enumeration

ResultFormat Enumeration

RetentionPeriodUnits Enumeration

RoleTypes Enumeration

Rule Class

RuleCollection Class

Scheduler Class

SchedulerCollection Class

Schema Class

SchemaCollection Class

SchemaCollectionBase Class

SchemaCustomResolver Class

SchemaEvents Class

ScriptingErrorEventArgs Class

ScriptingErrorEventHandler Delegate

ScriptingFilter Delegate

ScriptingOptions Class

ScriptNameObjectBase Class

ScriptOption Class

ScriptSchemaObjectBase Class

ScriptWriterException Class

SearchProperty Class

SearchPropertyCollection Class

SearchPropertyList Class

SearchPropertyListCollection Class

SecondaryXmlIndexType Enumeration

SequenceCacheType Enumeration

SequenceCollection Class

SequenceEvents Class

Server Class

ServerActiveDirectory Class

ServerAdapter Class

ServerAdapterBase Class

ServerAuditSpecification Class

ServerAuditSpecificationCollection Class

ServerAuditSpecificationExtender Class

ServerConfigurationAdapter Class

ServerDdlTrigger Class

ServerDdlTriggerCollection Class

ServerDdlTriggerEvent Class

ServerDdlTriggerEventSet Class

ServerDdlTriggerExecutionContext Enumeration

ServerEvent Class

ServerEventArgs Class

ServerEventHandler Delegate

ServerEvents Class

ServerEventSet Class

ServerLoginMode Enumeration

ServerMirroringRole Enumeration

ServerPermission Class

ServerPermissionInfo Class

ServerPermissionSet Class

ServerPermissionSetValue Enumeration

ServerProxyAccount Class

ServerRole Class

ServerRoleCollection Class

ServerRoleEvents Class

ServerSecurityAdapter Class

ServerSelectionAdapter Class

ServerSetupAdapter Class

ServerStatus Enumeration

ServerSurfaceAreaAdapter Class

ServerTraceEvent Class

ServerTraceEventSet Class

ServiceBrokerPayload Class

ServiceMasterKey Class

ServiceQueueEvent Class

ServiceQueueEventSet Class

ServiceRequestException Class

ServiceStartMode Enumeration

SfcDependencyException Class

ShrinkMethod Enumeration

SimpleObjectCollectionBase Class

SmoApplication Class

SmoApplication.AnyObjectEventHandler Delegate

SmoApplication.DatabaseEventHandler Delegate

SmoApplication.ObjectAlteredEventHandler Delegate

SmoApplication.ObjectCreatedEventHandler Delegate

SmoApplication.ObjectDroppedEventHandler Delegate

SmoApplication.ObjectRenamedEventHandler Delegate

SmoCollectionBase Class

SmoDmfAdapter Class

SmoEventArgs Class

SmoException Class

SmoExceptionType Enumeration

SmoObjectBase Class

SmoObjectExtender(T) Class

SnapshotIsolationState Enumeration

SoapMethodCollectionBase Class

SoapMethodObject Class

SoapPayload Class

SoapPayloadMethod Class

SoapPayloadMethodCollection Class

SortedListCollectionBase Class

SortOrder Enumeration

SpatialGeoLevelSize Enumeration

SpatialIndexType Enumeration

SqlAssembly Class

SqlAssemblyCollection Class

SqlAssemblyEvent Class

SqlAssemblyEvents Class

SqlAssemblyEventSet Class

SqlAssemblyFile Class

SqlAssemblyFileCollection Class

SqlDataType Enumeration

SqlPropertyCollection Class

SqlPropertyInfo Class

SqlServerRegistrations Class

SqlServerVersion Enumeration

SqlServerVersions Enumeration

SqlSmoObject Class

SqlSmoState Enumeration

SqlVerifyAction Enumeration

Statistic Class

StatisticCollection Class

StatisticColumn Class

StatisticColumnCollection Class

StatisticEvents Class

StatisticsScanType Enumeration

StatisticsTarget Enumeration

StopListOption Enumeration

StoredProcedure Class

StoredProcedureCollection Class

StoredProcedureEvent Class

StoredProcedureEvents Class

StoredProcedureEventSet Class

StoredProcedureParameter Class

StoredProcedureParameterCollection Class

SuspectPage Class

SymmetricKey Class

SymmetricKeyCollection Class

SymmetricKeyEncryption Class

SymmetricKeyEncryptionAlgorithm Enumeration

SymmetricKeyEncryptionType Enumeration

Synonym Class

SynonymBaseType Enumeration

SynonymCollection Class

SynonymEvents Class

SystemDataType Class

SystemDataTypeCollection Class

SystemMessage Class

SystemMessageCollection Class

Table Class

TableCollection Class

TableEvent Class

TableEvents Class

TableEventSet Class

TableViewBase Class

TableViewTableTypeBase Class

TcpProtocol Class

TerminationClause Enumeration

TransactionTypes Enumeration

TransferBase Class

Trigger Class

TriggerCollection Class

TriggerEvents Class

UnknownPropertyException Class

UnsupportedEngineTypeException Class

UnsupportedFeatureException Class

UnsupportedObjectNameException Class

UnsupportedVersionException Class

UrnCollection Class

UrnIdOption Enumeration

User Class

UserCollection Class

UserDefinedAggregate Class

UserDefinedAggregateCollection Class

UserDefinedAggregateParameter Class

UserDefinedAggregateParameterCollection Class

UserDefinedDataType Class

UserDefinedDataTypeCollection Class

UserDefinedDataTypeResolver Class

UserDefinedFunction Class

UserDefinedFunctionCollection Class

UserDefinedFunctionEvent Class

UserDefinedFunctionEvents Class

UserDefinedFunctionEventSet Class

UserDefinedFunctionParameter Class

UserDefinedFunctionParameterCollection Class

UserDefinedFunctionType Enumeration

UserDefinedMessage Class

UserDefinedMessageCollection Class

UserDefinedTableType Class

UserDefinedTableTypeCollection Class

UserDefinedTableTypeResolver Class

UserDefinedType Class

UserDefinedTypeCollection Class

UserDefinedTypeEvents Class

UserDefinedTypeFormat Enumeration

UserDefinedTypeResolver Class

UserEvents Class

UserOptions Class

UserType Enumeration

VerifyCompleteEventArgs Class

VerifyCompleteEventHandler Delegate

VersionSerializationAdapter Class

View Class

ViewCollection Class

ViewEvent Class

ViewEvents Class

ViewEventSet Class

WindowsLoginAccessType Enumeration

WorkloadGroup Class

WorkloadGroupCollection Class

WorkloadGroupImportance Enumeration

WrongPropertyValueException Class

WsdlGeneratorOption Enumeration

XmlDocumentConstraint Enumeration

XmlFormatOption Enumeration

XmlSchemaCollection Class

XmlSchemaCollectionCollection Class

XmlTypeDerivation Enumeration

XmlTypeKind Enumeration

XsdSchemaOption Enumeration

Minimize

This topic has not yet been rated - Rate this topic

ForeignKeyAction Enumeration

SQL Server 2012

The ForeignKeyAction enumeration is a list of constant values that specify the action that is taken when the primary key reference by a foreign key is updated.

Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.SqlEnum (in Microsoft.SqlServer.SqlEnum.dll)

public enum ForeignKeyAction

	Member name	Description
	NoAction	No action is taken.
	Cascade	The modification is also made to the foreign key.
	SetNull	The foreign key is set to null.
	SetDefault	The foreign key is set to the default value.

The ForeignKeyAction enumeration class is served by the UpdateAction property and the DeleteAction property.

Reference

Microsoft.SqlServer.Management.Smo 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.