Delete From

Definition

The deleteFrom methods allows you to add the DELETE FROM clause to the query.

Available methods

1. deleteFrom(KTable kTable)

• kTable: is the table which will be added to FROM clause.

2. deleteFrom(KRaw kRaw)

• kRaw: is a raw content which will be added in the DELETE FROM clause.

Method hierarchy

The deleteFrom method can be used right after the following methods or objects:

• KBuilder, with, withRecursive

and the subsequent methods that can be called are:

• using, where, returning, execute

Example: KTable

Java code:

k
.deleteFrom(APP_USER)
.execute();

SQL generated:

DELETE
FROM app_user au;

Parameters:

• None

Example: KRaw

Java code:

k
.deleteFrom(raw("app_user au"))
.execute();

SQL generated:

DELETE
FROM app_user au;

Parameters:

• None