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.
Note
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.
To access application tables in the system database schema using OpenSQL, you have to create them using the Java Dictionary.
More information: Creating Tables
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.sqlfor user SUPERDBA with password mymaster.
|
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.
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.
SQL Studio