Deleting all Rows of a Table 

Use

You can use SQL Studio to delete all rows of a table.

Prerequisites

You have the required user authorizations.*

Procedure

1.       In the Catalog Manager, select the table for which you want to delete the rows.

2.       Choose Catalog Manager ® Delete All Rows

If you delete the rows of a synonym, you thereby delete the rows of the original database table.

*For an explanation of user authorizations, see the User Concept section of the documentation The SAP DB Database System.