SQL Server

United States (English) Sign in

Print This Topic Print Multiple Topics

Home 2012 2008 R2 2008 Previous Versions Library Forums

TechNet Library

SQL Server

SQL Server 2012

Product Documentation

Developer Reference for SQL Server 2012

Developer Reference

Developer's Guide (Database Engine)

SQL Server Management Objects

SQL Server Management Objects Reference

Microsoft.SqlServer.Management.Smo

ForeignKey Class

ForeignKey Properties

Columns Property

CreateDate Property

DateLastModified Property

DeleteAction Property

ExtendedProperties Property

ID Property

IsChecked Property

IsEnabled Property

ISfcSupportsDesignMode.IsDesignMode Property

IsFileTableDefined Property

IsSystemNamed Property

Name Property

NotForReplication Property

Parent Property

ReferencedKey Property

ReferencedTable Property

ReferencedTableSchema Property

ScriptReferencedTable Property

ScriptReferencedTableSchema Property

UpdateAction Property

Minimize

This topic has not yet been rated - Rate this topic

ForeignKey.ReferencedKey Property

SQL Server 2012

SQL Server 2005

Gets the primary key referenced by the foreign key.

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

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)]
public string ReferencedKey { get; }

Property Value

Type: System.String
A String value that specifies the primary key referenced by the foreign key.

Creating, Altering, and Removing Foreign Keys

Reference

ForeignKey Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Creating and Modifying FOREIGN KEY Constraints

CREATE TABLE (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft

Manage Your Profile

|

Site Feedback

© 2013 Microsoft. All rights reserved.