TurboDB ADO.NET Data Provider

TurboDBDataReader.GetSchemaTable

Previous  Top  Next

Returns a DataTable, which describes the column meta data of the TurboDBDataReader.

C#

public DataTable GetSchemaTable()

Return Value

A DataTable describing the structure of the current result set of the data reader.

Implements

IDataReader.GetSchemaTable

Exceptions

InvalidOperationException        The TurboDBDataReader is closed.

Hints

Each row in the schema table describes one column in the result set. The schema table has these columns:

Name

Data Type

Description

ColumnName

string

The name of the column in the result set

Column Ordinal

int

The ordinal number of the column in the result set

ColumnSize

int

Maximum size of the data in the column

NumericPrecision

int

Numeric precision, if column data type is a real number

Numeric Scale

int

Number of digits to the right of the decimal separator (for real numbers)

DataType

Type

The .NET framework type of the column

ProviderType

TurboDBType

The TurboDB type of the column

IsLong

bool

True, if column is Blob or Memo

AllowDBNull

bool

True, if no value (i.e. a Null value) is allowed for the column

IsReadOnly

bool

True, if column must not be written to

IsRowVersion

bool

True, if column is of type AutoInc

IsUnique

bool

True, if there is a unique index on this column alone

IsKey

bool

True, if there is a unique index, whose fields are all in the result set and this column is one of them

BaseSchemaName

string

Always empty

BaseCatalogName

string

Always empty

BaseTableName

string

Name of database table, where this column is taken from

BaseColumnName

string

Name of this column in BaseTableName

See also

TurboDBDataReader Class | TurboDBDataReader Members