Jaa


Table.EnumForeignKeys Method

Enumerates a list of foreign keys defined on the table.

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

Syntax

'Declaration
Public Function EnumForeignKeys As DataTable
public DataTable EnumForeignKeys ()
public:
DataTable^ EnumForeignKeys ()
public DataTable EnumForeignKeys ()
public function EnumForeignKeys () : DataTable

Return Value

A DataTable system object value that contains a list of information about the foreign keys defined on the table. The table describes the different columns of the returned DataTable.

Column

Data type

Description

Table_Schema

String

The name of the schema associated with the table that contains the foreign key.

Table_Name

String

The name of the table that contains the foreign key.

Name

Int32

The name of the foreign key.

Remarks

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Example

How to: Create, Alter, and Remove a Table in Visual Basic .NET

Thread Safety

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

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

Table Class
Table Members
Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Creating, Altering, and Removing Tables
Tables
CREATE TABLE (Transact-SQL)