Creating Your Own Application Tables in the Database 

Use

Use this procedure to create database tables used by your application to store data.

The following options are possible:

●      Create the application tables in the system database schema to benefit from the OpenSQL infrastructure features;

●      Create application tables in a different schema on MaxDB database

If you want to create the application tables in a different schema than the system one on a database from a different vendor, you should contact your database product‘s documentation for description of the tools and procedures.

Creating Tables in the System Database

To access application tables in the system database schema using OpenSQL, you have to create them using the Java Dictionary.

More information: Tables

Creating Tables in MaxDB Using SQLCLI Script

You can use the command line tool SQLCLI to execute SQL script files that contain the definitions of your tables. For example, the following dialog would run the script demotables.sql for user SUPERDBA with password mymaster.

N:\>sqlcli -d JP1 -u superdba,mymaster Welcome to the MaxDB interactive terminal. sqlcli=> \i C:\myscripts\demotables.sql sqlcli=> \q

More information: demotables.sql

The SQLCLI command line tool offers much more functionality for entering and executing SQL statements, executing database procedures, and querying information about the database instance. For a complete list of commands, consult the “Tools” section in the online documentation for the MaxDB at dev.mysql.com.

Creating Tables in MaxDB Using SQL Studio

The SQL Studio is a GUI-based tool for creating tables and for managing the content of the MaxDB database. The SQL Studio and respective user documentation can be downloaded from dev.mysql.com.

With the SQL Studio you can not only create tables, but easily access all the application data as well as the database catalog of a MaxDB database instance. You can create, execute, and manage any number of SQL statements, and you can create, display, or change database catalog objects.