Mac Classic | Developer Tools | Schema

Schema - 2.0.1

SQL editor for REALbasic databases (was SQLVue)

(File Size: 1.0M)

Schema is an interactive development environment (IDE) for use with REALbasic databases.

Features

Connects to REALdb, MySQL, OpenBase and any database for which you have an ODBC driver, including Oracle and Access.
Can copy/convert any database to a REALbasic database (i.e. convert Access database to REALdatabase)
Schema browser displays tables, columns and scripts
SQL editor with syntax highlighting and command history
Export data as HTML or XML
Table designer
Data is displayed in sortable grids
Include DataList class that you can use in your projects royalty-free
Includes many sample databases

When copying to a REALdb, columns with a DataType of TimeStamp are converted to a VarChar to preserve the data. REALdb does not have a TimeStamp DataType.
Due to a bug in REALbasic, the Data List in the Schema Browser would crash if you had more than 50 or so columns on a table. Now only the first 50 are displayed.
When copying to a REALdb, tables that have spaces in the names are now preserved.
Built using REALbasic 5.2.4
Slightly smaller code size for Mac OS X and Classic builds

This product is designed to run on the following operating systems: