IMetabaseUpdateObjectNode.AlterType

Syntax

Description

The AlterType property determines when the object will be recreated on the DBMS level.

Comments

The property is relevant only for the following object classes: table, stored procedure, view.

Example

Executing the example requires that the repository contains an object with the TABLE identifier.

Sub UserProc;
Var
    Mb: IMetabase;
    MU: IMetabaseUpdate;
    Node: IMetabaseUpdateObjectNode;
Begin
    Mb := MetabaseClass.Active;
    MU := Mb.CreateUpdate;
    Node := MU.RootFolder.Add(MetabaseUpdateNodeType.Object) As IMetabaseUpdateObjectNode;
    Node.Object := Mb.ItemById("TABLE");
    Node.AlterType := MetabaseObjectAlterType.Recreate;
    MU.SaveToFileNF("c:\Update1.pefx");
End Sub UserProc;

After executing the example the update will be created. The table contained in the update will be recreated on the DBMS level during the update in any case.