Partager via

  • Article

ReferencedTable Property

Cette fonctionnalité sera supprimée dans une prochaine version de Microsoft SQL Server. Évitez d'utiliser cette fonctionnalité dans de nouveaux travaux de développement et prévoyez de modifier les applications qui utilisent actuellement cette fonctionnalité.

The ReferencedTable property specifies a Microsoft SQL Server table whose PRIMARY KEY constraint constrains values added to the table that owns the foreign key referenced by the Key object.

Syntaxe

object
.ReferencedTable [= value]

Parts

  • object
    An expression that evaluates to an object in the Applies To list

  • value
    A string that specifies a SQL Server table by name

Data Type

String

Modifiable

Read/write prior to foreign key definition. Read-only for Key objects referencing defined foreign keys.

Prototype (C/C++)

HRESULT GetReferencedTable(SQLDMO_LPBSTR pRetVal);
HRESULT SetReferencedTable(SQLDMO_LPCSTR NewValue);

Notes

SQL Distributed Management Objects (SQL-DMO) strings are always returned as OLE BSTR objects. A C/C++ application obtains a reference to the string. The application must release the reference using SysFreeString.

Notes

Setting the ReferencedTable property is required when defining a foreign key by using the Key object. For more information, see Key Object.

Applies To:

Key Object