Creating a Database Table 

Use

You can use SQL Studio to create new database tables in the database that you are logged on to. When you do so, you can use existing database tables or stored SQL Studio objects as a template for new database tables.

Prerequisites

You have the necessary user authorizations and have user attribute NOT EXCLUSIVE*.

Procedure

...

       1.      Choose Catalog Manager ®  New ® Table
The system opens a window for table definition.

       2.      To use an existing database table or stored SQL Studio object as a template for your new database table, select the required object in the Catalog Manager and copy it using the Drag&Drop function to the table definition window.

       3.      Enter a table name.

       4.      Carry out the following steps:

·         Defining Columns

·         Defining Constraints

·         Defining Foreign Key Dependencies (Referential Integrity)

·         Defining Miscellaneous Information

       5.      To use or edit your table draft again later, save it as an SQL Studio object by choosing Table Definition ® Save As.

       6.      Choose Table Definition ® Create Table. The system creates the new table in the database.

To export the SQL statement for creating the database table to the SQL dialog, choose Table Definition ® Export to SQL Dialog.

*For an explanation of user authorizations and user attributes, see the User Concept section of the documentation The SAP DB Database System and the Authorization section of the Reference Manual: SAP DB.

For information on the syntax of CREATE TABLE statements, see the CREATE TABLE Statement section of the Reference Manual: SAP DB.