Deleting from mulitple tables - quick qu

PhilBaker

Is there a way to delete data from multiple tables in a schema in a single command? We're looking for something like this:

 

delete from schema_name.* where ...

 

At the moment we either gather a list of all tables and write a separate delete statement for each one, or create a bash scripted loop.

 

Many thanks in advance for any advice.

SruthiA

Hi,

 

    Unfortunately, there is no way to delete data from more than one table using delete command. As mentioned by you, a bash script can achieve it.

 

 

-Regards,

 Sruthi