Create Table Assistant

One of the most important tasks in database management and (web) application development is to create new tables. As every database server features many enhancements to ANSI SQL this can be a quite complex task.

SQL4X Manager J includes the Create Table Assistant to make this task as easy as possible. The Create Table Assistant automatically recognizes Oracle, MS SQL Server, Sybase, MySQL, OpenBase and PostgreSQL database servers and displays all data types and special options supported by these database servers. For all other database server standard ANSI SQL92 options are displayed.

A detailed description on how to use the Create Table Assistant is in the section "Create Tables".

Note on special options

Every database vendor has it's own extension to standard SQL commands and many vendors choose different solutions for the same problem. Therefore not every option is enabled for every database server. For instance auto-incremental fields can be created through the special Column Extra "Auto Increment" with MySQL whereas Microsoft SQL Server features a special data type for auto-incremental fields.

The Create Table Assistant guides you as far as possible through the process of table creation, but you need a basic understanding of the features available with your database server to fully exploit all features of the Create Table Assistant.