본문으로 건너뛰기

how-to-delete-data-from-a-multi-index-table

Overview

This guide provides instructions to to delete data from a multi-index table.

Reference

See the following code reference:

Before you begin

Make sure you have the following prerequisites in place:

  • An Antelope development environment, for details consult the Get Started Guide,
  • A multi-index testab table instance which stores user objects indexed by the primary key which is of type eosio::name. Consult the section How to instantiate a multi-index table to learn how to set it up.

Procedure

Complete the following steps to implement a del action which deletes an user object, identified by its account name, from the multi-index table.

1. Find The User You Want To Delete

Use the multi-index find(...) method to locate the user object you want to delete. The targeted user is searched based on its account name.

[[eosio::action]] void multi_index_example::del( name user ) {
// check if the user already exists
auto itr = testtab.find(user.value);
}

2. Delete The User If Found

Check to see if the user exists and use erase(...) method to delete the row from table. Otherwise print an informational message and return.

[[eosio::action]] void multi_index_example::del( name user ) {
// check if the user already exists
auto itr = testtab.find(user.value);
+ if ( itr == testtab.end() ) {
+ printf("User does not exist in table, nothing to delete");
+ return;
+ }

+ testtab.erase( itr );
}
Full example location

A full example project demonstrating the instantiation and usage of multi-index table can be found here.

Summary

In conclusion, the above instructions show how to delete data from a multi-index table.

Next Steps

  • You can verify if the user object was deleted from the multi-index table. .
  // check if the user was deleted
auto itr = testtab.find(user.value);
if ( itr == testtab.end() ) {
printf("User was deleted successfully.");
}
else {
printf("User was NOT deleted!");
}