Deleting from mulitple tables - quick qu

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.

Comments

  • SruthiASruthiA Vertica Employee Administrator

    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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file