Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Gets or sets the table that contains the primary key referenced by the foreign key.
This API is not CLS-compliant.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase Or SfcPropertyFlags.Design)> _
<CLSCompliantAttribute(False)> _
<SfcReferenceAttribute(GetType(Table), "Server[@Name='{0}']/Database[@Name='{1}']/Table[@Name='{2}' and @Schema='{3}']", _
)> _
Public Property ReferencedTable As String
Get
Set
'Usage
Dim instance As ForeignKey
Dim value As String
value = instance.ReferencedTable
instance.ReferencedTable = value
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)]
[CLSCompliantAttribute(false)]
[SfcReferenceAttribute(typeof(Table), "Server[@Name='{0}']/Database[@Name='{1}']/Table[@Name='{2}' and @Schema='{3}']",
)]
public string ReferencedTable { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase|SfcPropertyFlags::Design)]
[CLSCompliantAttribute(false)]
[SfcReferenceAttribute(typeof(Table), L"Server[@Name='{0}']/Database[@Name='{1}']/Table[@Name='{2}' and @Schema='{3}']",
)]
public:
property String^ ReferencedTable {
String^ get ();
void set (String^ value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)>]
[<CLSCompliantAttribute(false)>]
[<SfcReferenceAttribute(typeof(Table), "Server[@Name='{0}']/Database[@Name='{1}']/Table[@Name='{2}' and @Schema='{3}']",
)>]
member ReferencedTable : string with get, set
function get ReferencedTable () : String
function set ReferencedTable (value : String)
Property Value
Type: System.String
A String value that specifies the referenced table.
Examples
Creating, Altering, and Removing Foreign Keys
See Also
Reference
Microsoft.SqlServer.Management.Smo Namespace