Class TTblInfo

Unit

Declaration

type TTblInfo = class()

Description

Use:
TableCount to get number of tables.
Table to get a table from defined by index.

Methods

Overview

	constructor Create;
	destructor Destroy; override;
	function GetDefaultsSQL (aStrs: TStringList): String;
	function GetIndexInfo (const anIdxName: String): TIdxInfo;

Description

constructor Create;

destructor Destroy; override;

function GetDefaultsSQL (aStrs: TStringList): String;

function GetIndexInfo (const anIdxName: String): TIdxInfo;

Properties

Overview

	property Field[const Idx: Integer]: TTblField;
	property FieldCount: Integer;
	property IdName: String;
	property Index[const Idx: Integer]: TIdxInfo;
	property IndexCount: Integer;
	property RootPage: Integer;
	property SQL: String;
	property TblName: String;
	property Typ: String;

Description

property Field[const Idx: Integer]: TTblField;

Access to field defined by it's position. See also TTblField.

property FieldCount: Integer;

Number of fields.

property IdName: String;

Table identifier, mostly the same as TblName.

property Index[const Idx: Integer]: TIdxInfo;

Access to index defined by it's position. See also TIdxInfo.

property IndexCount: Integer;

Number of indices.

property RootPage: Integer;

First page in file with data of the table.

property SQL: String;

SQL string (DDL) that was used to create table.

property TblName: String;

Table name.

property Typ: String;

Type, can be table or view.