Aracılığıyla paylaş

ForeignKey.Columns Property

  • Makale

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

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

Syntax

'Bildirim
<SfcObjectAttribute(SfcContainerRelationship.ChildContainer, SfcContainerCardinality.OneToAny, GetType(ForeignKeyColumn),  _
    SfcObjectFlags.None Or SfcObjectFlags.NaturalOrder Or SfcObjectFlags.Design)> _
Public ReadOnly Property Columns As ForeignKeyColumnCollection
    Get
'Kullanım
Dim instance As ForeignKey
Dim value As ForeignKeyColumnCollection

value = instance.Columns

[SfcObjectAttribute(SfcContainerRelationship.ChildContainer, SfcContainerCardinality.OneToAny, typeof(ForeignKeyColumn), 
    SfcObjectFlags.None|SfcObjectFlags.NaturalOrder|SfcObjectFlags.Design)]
public ForeignKeyColumnCollection Columns { get; }

[SfcObjectAttribute(SfcContainerRelationship::ChildContainer, SfcContainerCardinality::OneToAny, 
    typeof(ForeignKeyColumn), SfcObjectFlags::None|SfcObjectFlags::NaturalOrder|SfcObjectFlags::Design)]
public:
property ForeignKeyColumnCollection^ Columns {
    ForeignKeyColumnCollection^ get ();
}

[<SfcObjectAttribute(SfcContainerRelationship.ChildContainer, SfcContainerCardinality.OneToAny, 
    typeof(ForeignKeyColumn), SfcObjectFlags.None|SfcObjectFlags.NaturalOrder|SfcObjectFlags.Design)>]
member Columns : ForeignKeyColumnCollection

function get Columns () : ForeignKeyColumnCollection

Property Value

Type: Microsoft.SqlServer.Management.Smo.ForeignKeyColumnCollection
A ForeignKeyColumnCollection object that represents all the columns included in the foreign key.

Examples

Creating, Altering, and Removing Foreign Keys

See Also

Reference

ForeignKey Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Creating and Modifying FOREIGN KEY Constraints

CREATE TABLE (Transact-SQL)