ITable.AttachTable

Syntax

AttachTable(TableName: String; MakeExternal: Boolean);

Parameters

TableName is a physical name of the table that is a source of fields.

MakeExternal is the parameter defining that a table is external. If False is passed as the parameter value, table structure is updated, if True is passed, indicator of the external table is set for this table.

Description

The AttachTable method updates information about table structure in repository, according to table structure on database server. The information about structure of fields, indexes, triggers, table restrictions is updated. The method is also used to create an external table.

Example

Executing this example requires a database with the BD identifier. The database is configured for connection to database server, in which the table with the Table_1 physical name is contained.

Sub Main;

Var

Mb: IMetabase;

CrInfo: IMetabaseObjectCreateInfo;

MObj: IMetabaseObject;

Table: ITable;

Begin

Mb := MetabaseClass.Active;

CrInfo := MB.CreateCreateInfo;

CrInfo.ClassID := MetabaseObjectClass.KE_CLASS_EXTERNTABLE;

CrInfo.Id := "NewAttachTable";

CrInfo.Name := "NewAttachTable";

CrInfo.Parent := Mb.Root;

MObj := MB.CreateObject(CrInfo).Edit;

Table := MObj As ITable;

Table.Database := Mb.ItemById("BD").Bind As IDatabase;

Table.AttachTable("Table_1", True);

MObj.Save;

End Sub Main;

After executing the example, external tables are created in the repository root. This table refers to the table with the Table_1 physical name, stored on database server.