IMetabaseUpdateObjectNode.AlterType

Syntax

AlterType: MetabaseObjectAlterType;

Description

The AlterType property determines when the object will be recreated on the DBMS level. The property is relevant only for the following object 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;

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.

See also:

IMetabaseUpdateObjectNode