AlterTable

Modify an existing table.

Properties

alias : string

Physical 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 : string

Operation description.

hints : aspectList

List 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 : tableName

Table 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 : indexName

Table 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 : tableType

Table type. External tables are excluded from DDL scripts. Aspect table definition is appended to all matching pointcuts.

Valid values based on“string”.
managed	Managed 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.
external	External tables are excluded when generating DDL scripts and Prefixing.
query	The table is a cached result, a.k.a. materialized query table, a.k.a. materialized view, a.k.a. indexed view.
view	The table is a view.
aspect	Aspect 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

• RelationalDatabaseUpgrade - The set of Relational Upgrade steps to describe what schema changes took place in this version