MSDN Library

Servers and Enterprise Development

SQL Server

SQL Server 2005

Product Documentation

SQL Server 2005 Documentation

SQL Server 2005 Books Online

SQL Server Programming Reference

Database Engine Administration Programming

SQL Management Objects (SMO)

SMO Managed Programming Reference Documentation

SMO Class Library

Microsoft.SqlServer.Management.Smo

AbstractCollectionBase Class

ActivationExecutionContext 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

AuditLevel Enumeration

Backup Class

BackupActionType Enumeration

BackupDevice Class

BackupDeviceCollection Class

BackupDeviceItem Class

BackupDeviceList Class

BackupDeviceType Enumeration

BackupRestoreBase Class

BackupRestoreBase.AsyncOperation Enumeration

BackupSetFlag Enumeration

BackupSetType Enumeration

BackupTruncateLogType Enumeration

CatalogPopulationAction Enumeration

CatalogPopulationStatus Enumeration

Certificate Class

CertificateCollection Class

CertificateEvents Class

CertificateSourceType Enumeration

ChangeTracking Enumeration

Check Class

CheckCollection Class

CollectionNotAvailableException Class

Column Class

ColumnCollection Class

CompatibilityLevel Enumeration

ConfigProperty Class

ConfigPropertyCollection Class

Configuration Class

ConfigurationBase Class

Credential Class

CredentialCollection Class

Database Class

DatabaseActiveDirectory Class

DatabaseCollection Class

DatabaseDdlTrigger Class

DatabaseDdlTriggerCollection Class

DatabaseDdlTriggerEvent Class

DatabaseDdlTriggerEventSet Class

DatabaseDdlTriggerExecutionContext Enumeration

DatabaseEvent Class

DatabaseEventArgs Class

DatabaseEvents Class

DatabaseEventSet Class

DatabaseEventType Enumeration

DatabaseFile Class

DatabaseMapping Class

DatabaseMirroringPayload Class

DatabaseObjectTypes Enumeration

DatabaseOptions Class

DatabasePermission Class

DatabasePermissionInfo Class

DatabasePermissionSet Class

DatabasePermissionSetValue Enumeration

DatabaseRole Class

DatabaseRoleCollection Class

DatabaseStatus Enumeration

DatabaseUserAccess Enumeration

DataFile Class

DataFileCollection Class

DataType Class

DdlTextParserHeaderInfo Structure

DdlTriggerBase Class

Default Class

DefaultCollection Class

DefaultConstraint Class

DefaultRuleBase Class

Dependency Class

DependencyChainCollection Class

DependencyCollection Class

DependencyCollectionNode Class

DependencyNode Class

DependencyTree Class

DependencyTreeNode Class

DependencyType Enumeration

DependencyWalker Class

DeviceType Enumeration

Endpoint Class

EndpointAuthenticationOrder Enumeration

EndpointCollection Class

EndpointEncryption Enumeration

EndpointEncryptionAlgorithm Enumeration

EndpointPayload Class

EndpointProtocol Class

EndpointState Enumeration

EndpointType Enumeration

EnumeratorException Class

EventProperty Class

EventPropertyCollection Class

EventSetBase Class

EventType Enumeration

ExecutionContext Enumeration

ExecutionStatus Enumeration

ExtendedProperty Class

ExtendedPropertyCollection Class

ExtendedStoredProcedure Class

ExtendedStoredProcedureCollection Class

FailedOperationException Class

FileGroup Class

FileGroupCollection Class

FileGrowthType Enumeration

FilterNode Class

FilterNode.Type Enumeration

ForeignKey Class

ForeignKeyAction Enumeration

ForeignKeyCollection Class

ForeignKeyColumn Class

ForeignKeyColumnCollection Class

FragmentationOption Enumeration

FullTextCatalog Class

FullTextCatalogCollection Class

FullTextIndex Class

FullTextIndexColumn Class

FullTextIndexColumnCollection Class

FullTextService Class

HttpAuthenticationModes Enumeration

HttpPortTypes Enumeration

HttpProtocol Class

IColumnPermission Interface

IExtendedProperties Interface

ImplementationType Enumeration

Index Class

IndexCollection Class

IndexedColumn Class

IndexedColumnCollection Class

IndexEnableAction Enumeration

IndexEvents Class

IndexKeyType Enumeration

IndexOperation Enumeration

IndexPopulationAction Enumeration

IndexPopulationStatus Enumeration

Information Class

InternalEnumeratorException Class

InternalSmoErrorException Class

InvalidConfigurationFileEnumeratorException Class

InvalidPropertyUsageEnumeratorException Class

InvalidQueryExpressionEnumeratorException Class

InvalidSmoOperationException Class

InvalidVersionEnumeratorException Class

InvalidVersionSmoOperationException Class

IObjectPermission Interface

IScriptable Interface

ITextObject Interface

JobScheduleCollectionBase Class

KeyEncryptionType Enumeration

Language Class

LanguageCollection Class

LinkedServer Class

LinkedServerCollection Class

LinkedServerLogin Class

LinkedServerLoginCollection Class

LinkedTableType Enumeration

LinkFieldType Enumeration

LockRequestStatus Enumeration

LogFile Class

LogFileCollection Class

Login Class

LoginCollection Class

LoginCreateOptions Enumeration

LoginEvents Class

LoginType Enumeration

LogReuseWaitStatus 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

NotYetImplementedEnumeratorException Class

NSActivationState Enumeration

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

ObjectProperty Class

ObjectPropertyUsages Enumeration

ObjectRenamedEventArgs Class

OleDbProviderSettings Class

OleDbProviderSettingsCollection Class

OrderBy Class

OrderBy.Direction Enumeration

PageVerify Enumeration

Parameter Class

ParameterBase Class

ParameterCollectionBase Class

PartitionFunction Class

PartitionFunctionCollection Class

PartitionFunctionEvents Class

PartitionFunctionParameter Class

PartitionFunctionParameterCollection Class

PartitionScheme Class

PartitionSchemeCollection Class

PartitionSchemeEvents Class

PartitionSchemeParameter Class

PartitionSchemeParameterCollection Class

Payload Class

PercentCompleteEventArgs Class

PercentCompleteEventHandler Delegate

PerfMonMode Enumeration

PermissionInfo Class

PermissionSetBase Class

PermissionState Enumeration

PrincipalType Enumeration

PrivateKeyEncryptionType Enumeration

PrivilegeTypes Enumeration

ProgressReportEventArgs Class

ProgressReportEventHandler Delegate

Property Class

PropertyCannotBeRetrievedException Class

PropertyCollection Class

PropertyNotSetException Class

PropertyReadOnlyException Class

PropertyTypeMismatchException Class

PropertyWriteException Class

Protocol Class

ProtocolType Enumeration

QueryNotSupportedEnumeratorException Class

RangeType Enumeration

RecoveryModel Enumeration

RelocateFile Class

RepairType Enumeration

ReplicationOptions Enumeration

ResourceUsage Enumeration

Restore Class

RestoreActionType Enumeration

RestoreType Enumeration

ResultFormat Enumeration

RoleTypes Enumeration

Rule Class

RuleCollection Class

Schema Class

SchemaCollection Class

SchemaCollectionBase Class

SchemaEvents Class

Scripter Class

ScriptingErrorEventArgs Class

ScriptingErrorEventHandler Delegate

ScriptingFilter Delegate

ScriptingOptions Class

ScriptNameObjectBase Class

ScriptOption Class

ScriptSchemaObjectBase Class

SecondaryXmlIndexType Enumeration

Server Class

ServerActiveDirectory 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

ServerTraceEvent Class

ServerTraceEventSet Class

ServiceBrokerPayload Class

ServiceMasterKey Class

ServiceQueueEvent Class

ServiceQueueEventSet Class

ServiceRequestException Class

Settings 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

SmoApplication.SqlServerRegistrations Class

SmoCollectionBase Class

SmoEventArgs Class

SmoException Class

SmoExceptionType Enumeration

SmoObjectBase Class

SnapshotIsolationState Enumeration

SoapMethodCollectionBase Class

SoapMethodObject Class

SoapPayload Class

SoapPayloadMethod Class

SoapPayloadMethodCollection Class

SortedListCollectionBase Class

SortOrder Enumeration

SqlAssembly Class

SqlAssemblyCollection Class

SqlAssemblyEvent Class

SqlAssemblyEvents Class

SqlAssemblyEventSet Class

SqlAssemblyFile Class

SqlAssemblyFileCollection Class

SqlDataType Enumeration

SqlPropertyCollection Class

SqlPropertyInfo 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

StoredProcedure Class

StoredProcedureCollection Class

StoredProcedureEvent Class

StoredProcedureEvents Class

StoredProcedureEventSet Class

StoredProcedureParameter Class

StoredProcedureParameterCollection Class

SymmetricKey Class

SymmetricKeyCollection Class

SymmetricKeyEncryption Class

SymmetricKeyEncryptionAlgorithm Enumeration

SymmetricKeyEncryptionType Enumeration

Synonym Class

SynonymCollection Class

SynonymEvents Class

SystemDataType Class

SystemDataTypeCollection Class

SystemMessage Class

SystemMessageCollection Class

Table Class

TableCollection Class

TableEvent Class

TableEvents Class

TableEventSet Class

TableViewBase Class

TcpProtocol Class

TerminationClause Enumeration

TransactionTypes Enumeration

Transfer Class

Trigger Class

TriggerCollection Class

TriggerEvents Class

UnknownPropertyEnumeratorException Class

UnknownPropertyException Class

UnknownTypeEnumeratorException Class

UnsupportedFeatureException Class

UnsupportedObjectNameException Class

UnsupportedVersionException Class

Urn Class

UrnCollection Class

User Class

UserCollection Class

UserDefinedAggregate Class

UserDefinedAggregateCollection Class

UserDefinedAggregateParameter Class

UserDefinedAggregateParameterCollection Class

UserDefinedDataType Class

UserDefinedDataTypeCollection Class

UserDefinedFunction Class

UserDefinedFunctionCollection Class

UserDefinedFunctionEvent Class

UserDefinedFunctionEvents Class

UserDefinedFunctionEventSet Class

UserDefinedFunctionParameter Class

UserDefinedFunctionParameterCollection Class

UserDefinedFunctionType Enumeration

UserDefinedMessage Class

UserDefinedMessageCollection Class

UserDefinedType Class

UserDefinedTypeCollection Class

UserDefinedTypeEvents Class

UserDefinedTypeFormat Enumeration

UserEvents Class

UserOptions Class

UserType Enumeration

VerifyCompleteEventArgs Class

VerifyCompleteEventHandler Delegate

View Class

ViewCollection Class

ViewEvent Class

ViewEvents Class

ViewEventSet Class

WindowsLoginAccessType Enumeration

WrongPropertyValueException Class

WsdlGeneratorOption Enumeration

XmlDocumentConstraint Enumeration

XmlFormatOption Enumeration

XmlSchemaCollection Class

XmlSchemaCollectionCollection Class

XmlTypeDerivation Enumeration

XmlTypeKind Enumeration

XmlUtility Class

XPathException Class

XPathExceptionCode Enumeration

XPathExpression Class

XPathExpressionBlock Class

XsdSchemaOption Enumeration

Community Content

Add code samples and tips to enhance this topic.

More...

This topic has not yet been rated - Rate this topic

ForeignKeyAction Enumeration

SQL Server 2005

The ForeignKeyAction enumeration is a list of constant values that specify the action 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)

Copy

public enum ForeignKeyAction

Copy

public enum ForeignKeyAction

Copy

public enum ForeignKeyAction

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

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

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

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 Content Add

Annotations

FAQ

© 2012 Microsoft. All rights reserved.

Terms of Use | Trademarks | Privacy Statement | Site Feedback Site Feedback

Site Feedback

x

Tell us about your experience...

Did the page load quickly?

Yes No

Do you like the page design?

Yes No

Tell us more