You use this method to delete the entire contents of table collection.
CALL METHOD link_server->remove_all_tables EXPORTING no_flush = no_flush IMPORTING error = error retcode = retcode.