Table Operations (Release 9.2.26.0)

Starting with Tools Release 9.2.26.0, you can run Table Operations on Web OMW. Table operations enable you to perform actions on physical tables within a database. These operations ensure that the physical attributes of a database table align with the user specifications defined in EnterpriseOne.

You can complete all table operations directly from Web OMW including: Table Generation, Index Generation, Copy Table, and Drop Table.

Additionally, you can perform operations such as:

• Index Generation: Currently, when using the Generate Index function, EnterpriseOne generates all indexes defined in the user specifications on development client. Web OMW provides you an option to selectively generate specific indexes.
• Table Generation for Existing Data: When generating a table that already contains data (with added column only in table spec), you can use an ALTER command, to modify physical table and match the specifications without losing existing data.