deleteReturning

fun <T : Table> T.deleteReturning(returning: List<Expression<*>> = columns, where: SqlExpressionBuilder.() -> Op<Boolean>? = null): ReturningStatement

Represents the SQL statement that deletes rows in a table and returns specified data from the deleted rows.

Return

A ReturningStatement that will be executed once iterated over, providing ResultRows containing the specified expressions mapped to their resulting data.

Parameters

returning

Columns and expressions to include in the returned data. This defaults to all columns in the table.

where

Condition that determines which rows to delete. If left as null, all rows in the table will be deleted.

Samples

org.jetbrains.exposed.sql.tests.shared.dml.ReturningTests.testDeleteReturning