Working with Truncate

This method is used to remove all records in a table. All records afterward are irrecoverable. It is extremely fast, dependent on table size.

This will truncate the whole table, but won’t delete the table itself.

Truncate Examples

Agent RESTful API
Core API

using SuperOffice.WebApi;
using SuperOffice.WebApi.Data;
using SuperOffice.WebApi.Agents;

// set up the DatabaseTable agent

WebApiOptions options = //Get WebApiOptions with SystemUser Authorization
DatabaseTableAgent dta = new DatabaseTableAgent(options);

// table name

string tableName = "y_rental";

MassOperationResult massResult = await dta.TruncateAsync(tableName);

if(massResult.Success)
{
    Console.WriteLine($"Removed {massResult.Deletes} records from {tableName}.");
}

using SuperOffice.Data.Dialect;

var mo = MassOperations.GetCurrent();

// table name

string tableName = "y_rental";

MassResult massResult = mo.Truncate(tableName);

if(massResult.Success)
{
    Console.WriteLine($"Removed {massResult.Deletes} records from {tableName}.");
}

​Truncate Examples

Truncate Examples