Get Definition of a View (Magic xpa 4.x)

SQL offers view definitions, which can be accessed in the same way as the table definitions are accessed. An SQL view is a virtual table defined by a query.

You can access an SQL view in query mode, and in some cases depending on the RDBMS, update them just as if they were tables in the RDBMS.

A view does not contain an index. Therefore when loading a view, you must define a virtual unique index. This is because Magic xpa must have a position for the table.

In some cases, the view has a ROWID so there is no need to define a virtual index; you only need to set the position as ROWID.