Solution for Drop multiple tables at once in ClickHouse
is Given Below:
I’m trying to drop a few tables at once on a ClickHouse cluster. As example:
DROP TABLE IF EXISTS default.log_null, default.null_view
I get the error:
Code: 62, e.displayText() = DB::Exception: Syntax error: failed at position 39 (','): , default.null_view. Expected one of: NO DELAY, end of query, INTO OUTFILE, SETTINGS, ON, FORMAT, SYNC (version 18.104.22.168 (official build))
What is the correct syntax if such action is supported?