Share via

  • Article

ForeignKeyColumn Class

The ForeignKeyColumn object represents a SQL Server foreign key column.

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

Syntax

'Declaration
<SfcElementTypeAttribute("Column")> _
Public NotInheritable Class ForeignKeyColumn _
    Inherits NamedSmoObject _
    Implements IPropertyDataDispatch
'Usage
Dim instance As ForeignKeyColumn

[SfcElementTypeAttribute("Column")]
public sealed class ForeignKeyColumn : NamedSmoObject, 
    IPropertyDataDispatch

[SfcElementTypeAttribute(L"Column")]
public ref class ForeignKeyColumn sealed : public NamedSmoObject, 
    IPropertyDataDispatch

[<SealedAttribute>]
[<SfcElementTypeAttribute("Column")>]
type ForeignKeyColumn =  
    class
        inherit NamedSmoObject
        interface IPropertyDataDispatch
    end

public final class ForeignKeyColumn extends NamedSmoObject implements IPropertyDataDispatch

Remarks

To get ForeignKeyColumn object properties, users can be a member of the public fixed server role.

To set ForeignKeyColumn object properties, users must have ALTER permission on the parent table or be a member of the db_owner fixed database role.

To create or drop a foreign key column, users must have ALTER permission on the parent table or be a member of the db_owner fixed database role.

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are safe for multithreaded operations. Any instance members are not guaranteed to be thread safe.

Inheritance Hierarchy

System.Object
  Microsoft.SqlServer.Management.Smo.SmoObjectBase
    Microsoft.SqlServer.Management.Smo.SqlSmoObject
      Microsoft.SqlServer.Management.Smo.NamedSmoObject
        Microsoft.SqlServer.Management.Smo.ForeignKeyColumn

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.