AlterTable
Modify an existing table.
Properties
alias : stringPhysical name of the table. Overrides the name and the prefix. It should be properly quoted, if necessary. Allowed only in non-portable schemas for non-managed tables.description : stringOperation description.hints : aspectListList of hints to add or remove from the table. To remove a hint prefix it with a '!'.Valid values based on“token”.(!?:?[\p{L}_][\p{L}\p{N}_]*(:[\p{L}_][\p{L}\p{N}_]*)*\s+)*(!?:?[\p{L}_][\p{L}\p{N}_]*(:[\p{L}_][\p{L}\p{N}_]*)*)?Each element in the list must begin with a letter or underscore. Elements are space delimited. To exclude a token, prefix it with the character "!".name : tableNameTable name, as specified in the data source: [<owner>.]<table>Valid values based on“string”.[A-Za-z][_A-Za-z\d]*(\.[A-Za-z][_A-Za-z\d]*)?primaryKey : indexNameTable primary key unique index. For query tables use a virtual index.Valid values based on“string”.[A-Za-z][_A-Za-z\d]*(\.[A-Za-z][_A-Za-z\d]*){0,2}type : tableTypeTable type. External tables are excluded from DDL scripts. Aspect table definition is appended to all matching pointcuts.Valid values based on“string”.managedManaged tables are managed by the upgrade framework. They are included when generating upgrade, create, drop... DDL scripts. Prefixing is also applied to this type of table.externalExternal tables are excluded when generating DDL scripts and Prefixing.queryThe table is a cached result, a.k.a. materialized query table, a.k.a. materialized view, a.k.a. indexed view.viewThe table is a view.aspectAspect tables are table elements (columns, indexes, ...) that may be appended to other "managed" tables. They do not represent real tables in the generated schema. An Aspect Table is appended to all tables (or other Aspects) that either specify it by name in their "aspects" property or match the Aspect Table's "pointcut" property. If a table matches the aspect's "poincut" property but excludes the aspect by name in its "aspects" property, the aspect will not be applied to that table.
Parents
-
t_Upgrade_RelationalDatabaseUpgrade - The set of Relational Upgrade steps to describe what schema changes took place in this version
Parent topic: t_Upgrade_RelationalDatabaseUpgrade