OleDbSchemaGuid.Columns Field

Definition

Namespace:

System.Data.OleDb

Assembly:

System.Data.OleDb.dll

Package:

System.Data.OleDb v9.0.0

Source:

OleDbSchemaGuid.cs

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

public: static initonly Guid Columns;

public static readonly Guid Columns;

 staticval mutable Columns : Guid

Public Shared ReadOnly Columns As Guid 

Field Value

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.