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

public static readonly Guid Columns
public static final Guid Columns
public static final var Columns : Guid
Not applicable.

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

Restriction column

CLR data type




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



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



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



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.

Windows 98, Windows Server 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 Microsoft .NET Framework 3.0 is supported on Windows Vista, Microsoft Windows XP SP2, and Windows Server 2003 SP1.

.NET Framework

Supported in: 3.0, 2.0, 1.1, 1.0