.NET Framework Class Library
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)
Syntax

Visual Basic (Declaration)
Public Shared ReadOnly Columns As Guid
Visual Basic (Usage)
Dim value As Guid

value = OleDbSchemaGuid.Columns
C#
public static readonly Guid Columns
Visual C++
public:
static initonly Guid Columns
JScript
public static final var Columns : Guid
Remarks

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. (DBID is a formal structure serialized into the COLUMN_NAME column of the COLUMN_DOMAIN_USAGE rowset.) 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.

Platforms

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

The .NET Framework and .NET Compact Framework do not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.
Version Information

.NET Framework

Supported in: 3.5, 3.0, 2.0, 1.1, 1.0
See Also

Reference

Tags :


Page view tracker