IMetabaseUpdateObjectNode.AlterType

Syntax

AlterType: MetabaseObjectAlterType;

Description

The AlterType property determines the case when the object will be recreated on the DBMS level.This property is relevant only for the following objects classes: table, stored procedure, view.

Example

Sub UserProc;

Var

Mb: IMetabase;

U: IMetabaseUpdate;

N: IMetabaseUpdateObjectNode;

Begin

Mb := MetabaseClass.Active;

U := Mb.CreateUpdate;

N := U.RootFolder.Add(MetabaseUpdateNodeType.Object) As IMetabaseUpdateObjectNode;

N.Object := Mb.ItemById("TABLE");

N.AlterType := MetabaseObjectAlterType.Recreate;

U.SaveToFileNF("c:\temp\Update1.pefx");

End Sub UserProc;

An update will be created after example execution. The table, contained in the update, will be recreated on DBMS level during updating in any case.

See also:

IMetabaseUpdateObjectNode