ForeignKey Properties

ForeignKey Properties

 

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

NameDescription
System_CAPS_pubpropertyColumns

Represents a collection of Column objects. Each Column object represents a column included in the foreign key.

System_CAPS_pubpropertyCreateDate

Gets the date and time when the foreign key was created.

System_CAPS_pubpropertyDateLastModified

Gets the date and time when the foreign key was last modified.

System_CAPS_pubpropertyDeleteAction

Gets or sets the action taken when the row that is referenced by the foreign key is deleted.

System_CAPS_pubpropertyExecutionManager

(Inherited from SqlSmoObject.)

System_CAPS_pubpropertyExtendedProperties

Represents a collection of ExtendedProperty objects. Each ExtendedProperty object represents an extended property on the ForeignKey object.

System_CAPS_pubpropertyID

Gets the ID value that uniquely identifies the foreign key.

System_CAPS_pubpropertyIsChecked

Gets or sets the Boolean property value that specifies whether the foreign key constraint was enabled without checking existing rows.

System_CAPS_pubpropertyIsEnabled

Gets or sets the Boolean property value that specifies whether the foreign key is enabled.

System_CAPS_pubpropertyIsFileTableDefined

Gets or sets whether the file table is defined.

System_CAPS_pubpropertyIsMemoryOptimized

System_CAPS_pubpropertyIsSystemNamed

Gets the Boolean property value that specifies whether the foreign key is named by the system or by the user.

System_CAPS_pubpropertyName

Gets or sets the name of the foreign key.(Overrides NamedSmoObject.Name.)

System_CAPS_pubpropertyNotForReplication

Gets the Boolean property value that specifies whether the foreign key is available for replication.

System_CAPS_pubpropertyParent

Gets or sets the Table object that is the parent of the ForeignKey object.

System_CAPS_pubpropertyProperties

Gets a collection of Property objects that represent the object properties.(Inherited from SqlSmoObject.)

System_CAPS_pubpropertyReferencedKey

Gets the primary key referenced by the foreign key.

System_CAPS_pubpropertyReferencedTable

Gets or sets the table that contains the primary key referenced by the foreign key.

System_CAPS_pubpropertyReferencedTableSchema

Gets or sets the table schema that contains the primary key referenced by the foreign key.

System_CAPS_pubpropertyScriptReferencedTable

Gets or sets the Boolean value that specifies whether to script the table referenced by the foreign key.

System_CAPS_pubpropertyScriptReferencedTableSchema

Gets or sets the Boolean value that specifies whether to script the schema of the table referenced by the foreign key.

System_CAPS_pubpropertyState

Gets the state of the referenced object.(Inherited from SmoObjectBase.)

System_CAPS_pubpropertyUpdateAction

Gets or sets the Boolean property value that specifies whether the foreign key supports cascading updates.

System_CAPS_pubpropertyUrn

Gets the Uniform Resource Name (URN) address value that uniquely identifies the object.(Inherited from SqlSmoObject.)

System_CAPS_pubpropertyUserData

Gets or sets user-defined data associated with the referenced object.(Inherited from SmoObjectBase.)

Return to top
Show:
© 2016 Microsoft