Tutorial by Topics: delete



The DELETE statement is used to delete records from a table.

This sample shows how to mass delete records in NetSuite by leveraging the Mass Update feature. Typically, we're told not to delete records, but to make records inactive, but if you must, then this small script does just that. Once the script is deployed as a 'Mass Update' script type, simply go to Lists > Mass Update > Mass Updates > Custom Updates. You should see your mass delete. Next, set up your search criteria in your mass delete and do a preview to validate your data before deleting.

Sql script to delete test data of products, customers, logs and sales.

Removing old data from dynamodb using a date attribute.


Page 1 of 1