Tables

You can create new LANSA-defined SQL table definitions by:

      File -> New -> Table

      Copying an existing table definition.

      Using the Visual LANSA Logical Modeler

We use the word "new" because when you create a table this way, the table doesn’t already exist and when you compile it, the table, indexes and an Object Access Module are created.

You can also define an existing SQL table to LANSA by importing its definition into the Repository. Because the table definition is imported, only an Object Access Module is created when you compile it. The table definition is "owned by" the application in which it was created.

Regardless of how the table is defined, you can enhance the table's definition with business rules, virtual fields and pre-determined join fields.

See Create Tables.

See Visual LANSA Logical Modeler.