Magic xpa with an SQL Client (Magic xpa 3.x)
It is recommended to create database objects, data sources and indexes, by using SQL Scripts and then retrieve the SQL Scripts in Magic xpa by using the Get File Definition function.
It is best to use the SQL Gateway, not the ISAM Gateway or DDS, to create new tables and indexes in the SQL Collection (Library).
Using the SQL Gateway
Built-in Open Query by SQL SELECT Statements