Database tables and open SQL

Add a single record to a database table

insert into values

Inserting all lines from an internal table into a database table:

insert from table

Delete all records

Select * from zmellemtab.
delete zmellemtab.
endselect.

Deleting records using records from an internal table

delete employees from table itab.