I want to drop few phoenix table in using a sqlline.py.
Can I write a drop_table.hql and exeucte in phoenix shell ?
As @ssattiraju mentioned you may use a file with commands providing it as a command line parameter. One quick note - if one of the commands fail, the script will stop executing. To avoid it you may use just simple redirect like:
phoenix-sqlline localhost < file.sql