Show TOC

Creating Your Own Application Tables in the DatabaseLocate this document in the navigation structure

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.

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.

Procedure

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.htmInformation published on SAP site.