It is recommended that you use the native tool for creating and maintaining SQL databases.
Before you can access the tables of an SQL database in a DataFlex Workspace, you will need to create 'table descriptions'. Table descriptions are stored in .INT files in the workspace's Data folder. One .INT file is maintained for each table that you will use in the workspace.
The DataFlex Studio contains an SQL Connect/Repair Wizard that can build and maintain these .INT files for you. We recommend that you use Managed Connections, which you can configure using the SQL Connection Manager (Database > SQL Connection Manger) menu, as well as, from inside the SQL Connect/Repair Wizard.
To start this wizard, select "SQL Connect/Repair Wizard" from the Database menu.
Each time that a database is modified, e.g. a table structure is changed, or a new table is added, etc, you should run the connection wizard to import the necessary changes into the DataFlex table descriptions.