deleteAllFrom

open fun deleteAllFrom(schemaName: String? = defaultSchemaName)

Deletes all data from tables within the specified schema. If there is null, then the tables not associated with a schema are deleted.

Uses the longLastingConnection property for the connection.

Parameters

schemaName

the name of the schema containing the table


open fun deleteAllFrom(tableNames: List<String>, schemaName: String? = defaultSchemaName)

Deletes all data from the tables in the list.

Uses the longLastingConnection property for the connection.

Parameters

tableNames

the table to delete from

schemaName

the name of the schema containing the table


open fun deleteAllFrom(tableName: String, schemaName: String? = defaultSchemaName): Boolean

Deletes all data from the named table.

Uses the longLastingConnection property for the connection.

Return

true if the command executed successfully.

Parameters

tableName

the table to delete from

schemaName

the name of the schema containing the table