This documentation is archived and is not being maintained.

OleDbSchemaGuid.Columns Field

Returns the columns of tables (including views) defined in the catalog that is accessible to a given user.

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

public static readonly Guid Columns
public static final Guid Columns
public static final var Columns : Guid

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

Restriction column

CLR data type

Description

TABLE_CATALOG

string

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

TABLE_SCHEMA

string

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

TABLE_NAME

string

Table name. The column returned cannot contain a null value.

COLUMN_NAME

string

The name of the column; this might not be unique. If this cannot be determined, a null value is returned. This column, together with the COLUMN_GUID and COLUMN_PROPID columns, forms the column ID. One or more of these columns will be a null value, depending on which elements of the DBID structure the provider uses. If possible, the resulting column ID should be persistent. However, some providers do not support persistent identifiers for columns. The column ID of a base table should be invariant under views.

Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see System Requirements.

.NET Framework

Supported in: 2.0, 1.1, 1.0
Show: