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.
For more information, see 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 |
For more information, see 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 Database Studio
Database Studio is a database tool with which you can manage SAP MaxDB databases of version 7.5 and higher. It is a component of the SAP MaxDB software. You can use Database Studio on all operating systems supported by the database system.
For more information, see http://maxdb.sap.com/doc/7_8/e9/005dac1592496783e26133eb7fad0b/frameset.htm.