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 SAP 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.

You can also create your database tables using the SQL Development Tools. For more information, refer to the Data Tools Platform User Guide, provided by the SAP NetWeaver Developer Studio help content.

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: Creating Tables

Creating Tables in SAP 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 relevant version of SAP MaxDB at http://maxdb.sap.com/documentation.

Creating Tables in SAP MaxDB Using SQL Studio

The SQL Studio is a GUI-based tool for creating tables and for managing the content of the SAP MaxDB database. The SQL Studio and respective user documentation can be downloaded from http://www.sdn.sap.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 SAP MaxDB database instance. You can create, execute, and manage any number of SQL statements, and you can create, display, or change database catalog objects.