AnsweredAssumed Answered

Drop several Tables at once ?

Question asked by Vincent_L on Jun 25, 2018
Latest reply on Jun 26, 2018 by user19752

Hi,

With Base Element Plugins (or others), we can launch altering tables and schema queries.

One of which, is Drop Table. But apparently I didn't find a way to drop several drop table at once. This has the disadvantage of initiating each time a lengthy "rebuilding dependencies" process.

 

So is there a syntax to drop several tables at once ?

 

I tried :

- DROP TABLE ('TA','TB')

- DROP TABLE IN ('TA','TB')

- DROP TABLE IN ("TA","TB")

- DROP TABLE WHERE TableName IN ('TA','TB')

- DROP TABLE IN "TA","TB"

 

None of them worked

 

Only individual DROP TABLE IN "TA" and DROP TABLE IN "TB" worked.

 

So am-I missing something ?

Did someone succeeded to drop several tables at one ?

 

Thanks

Outcomes