Changing the Definition of a Database Table 

Use

You can use SQL Studio to change the definition of a database table.

Prerequisites

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

Procedure

1.       Select the table and choose Catalog Manager ® Alter Table.
The system opens a window for table definition.

2.       Make the required changes:

·         Defining Columns

·         Defining Constraints

·         Defining Foreign Key Dependencies (Referential Integrity)

·         Defining Miscellaneous Information

Choose Table Definition ® Alter Table.

To export the SQL statement for changing 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 ALTER TABLE statements, see the ALTER TABLE Statement section of the Reference Manual: SAP  DB.