delete
Represents the SQL statement that deletes rows from a table in a join relation.
Return
The number of deleted rows.
Parameters
The specific table from this join relation to delete rows from.
(Optional) Other tables from this join relation to delete rows from. Note Targeting multiple tables for deletion is not supported by all vendors. Please check the documentation.
Whether to ignore any possible errors that occur when deleting rows. Note ignore is not supported by all vendors. Please check the documentation.
Maximum number of rows to delete. Note limit is not supported by all vendors. Please check the documentation.
Condition that determines which rows to delete.
Samples
org.jetbrains.exposed.sql.tests.shared.dml.DeleteTests.testDeleteWithSingleJoinRepresents the SQL statement that deletes all rows from a table in a join relation.
Return
The number of deleted rows.
Parameters
The specific table from this join relation to delete rows from.
(Optional) Other tables from this join relation to delete rows from. Note Targeting multiple tables for deletion is not supported by all vendors. Please check the documentation.
Whether to ignore any possible errors that occur when deleting rows. Note ignore is not supported by all vendors. Please check the documentation.
Maximum number of rows to delete. Note limit is not supported by all vendors. Please check the documentation.
Samples
org.jetbrains.exposed.sql.tests.shared.dml.DeleteTests.testDeleteWithSingleJoinDeprecated
This `Join.delete()` with a nullable `where` parameter will be removed in future releases. Please leave a comment on [YouTrack](https://youtrack.jetbrains.com/issue/EXPOSED-494/Inline-DSL-statement-and-query-functions) with a use-case if a nullable condition cannot be replaced with the new `Join.delete()` overloads.
Replace with
delete(targetTable, targetTables = targetTables, ignore, limit)