Export (0) Print
Expand All

ForeignKey Properties

The ForeignKey type exposes the following members.

  Name Description
Public property Columns Represents a collection of Column objects. Each Column object represents a column included in the foreign key.
Public property CreateDate Gets the date and time when the foreign key was created.
Public property DateLastModified Gets the date and time when the foreign key was last modified.
Public property DeleteAction Gets or sets the action taken when the row that is referenced by the foreign key is deleted.
Public property ExtendedProperties Represents a collection of ExtendedProperty objects. Each ExtendedProperty object represents an extended property on the ForeignKey object.
Public property ID Gets the ID value that uniquely identifies the foreign key.
Public property IsChecked Gets or sets the Boolean property value that specifies whether the foreign key constraint was enabled without checking existing rows.
Public property IsEnabled Gets or sets the Boolean property value that specifies whether the foreign key is enabled.
Public property IsFileTableDefined Gets or sets whether the file table is defined.
Public property IsSystemNamed Gets the Boolean property value that specifies whether the foreign key is named by the system or by the user.
Public property Name Gets or sets the name of the foreign key. (Overrides NamedSmoObject.Name.)
Public property NotForReplication Gets the Boolean property value that specifies whether the foreign key is available for replication.
Public property Parent Gets or sets the Table object that is the parent of the ForeignKey object.
Public property Properties Gets a collection of Property objects that represent the object properties. (Inherited from SqlSmoObject.)
Public property ReferencedKey Gets the primary key referenced by the foreign key.
Public property ReferencedTable Gets or sets the table that contains the primary key referenced by the foreign key.
Public property ReferencedTableSchema Gets or sets the table schema that contains the primary key referenced by the foreign key.
Public property ScriptReferencedTable Gets or sets the Boolean value that specifies whether to script the table referenced by the foreign key.
Public property ScriptReferencedTableSchema Gets or sets the Boolean value that specifies whether to script the schema of the table referenced by the foreign key.
Public property State Gets the state of the referenced object. (Inherited from SmoObjectBase.)
Public property UpdateAction Gets or sets the Boolean property value that specifies whether the foreign key supports cascading updates.
Public property Urn Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (Inherited from SqlSmoObject.)
Public property UserData Gets or sets user-defined data associated with the referenced object. (Inherited from SmoObjectBase.)
Top

  Name Description
Explicit interface implemetation Private property ISfcSupportsDesignMode.IsDesignMode Gets a Boolean value that indicates whether the object supports design mode. Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.
Top

Community Additions

ADD
Show:
© 2014 Microsoft