OleDbSchemaGuid.Table_Constraints Field

 

Returns the table constraints defined in the catalog that is owned by a given user.

Namespace:   System.Data.OleDb
Assembly:  System.Data (in System.Data.dll)

public static readonly Guid Table_Constraints

Field Value

Type: System.Guid

Table_Constraints maps to the OLE DB TABLE_CONSTRAINTS rowset. Unless otherwise specified, restriction columns are returned in the following order.

Restriction column

CLR data type

Description

CONSTRAINT_CATALOG

string

Catalog name. A null value if the provider does not support catalogs.

CONSTRAINT_SCHEMA

string

Unqualified schema name. A null value if the provider does not support schemas.

CONSTRAINT_NAME

string

Constraint name.

TABLE_CATALOG

string

Catalog name in which the table is defined. A null value if the provider does not support catalogs.

TABLE_SCHEMA

string

Unqualified schema name in which the table is defined. A null value if the provider does not support schemas.

TABLE_NAME

string

Table name.

CONSTRAINT_TYPE

string

Constraint type. One of the following: UNIQUE, PRIMARY KEY, FOREIGN KEY, or CHECK.

.NET Framework
Available since 1.1
Return to top
Show: