Sqlite drop table

How to delete table sqlite

# SQLite->
DROP TABLE table_name

Sqlite drop table

DROP TABLE IF EXISTS table_name

Delete table sqlite

import sqlite3
db = "./db.sqlite3"
conn = sqlite3.connect(db)
conn.execute("DROP TABLE paintshop_category" )
conn.commit()
conn.close()
print('success')

SQLite Drop Table

cmd.CommandText = "DROP TABLE IF EXISTS cars";
cmd.ExecuteNonQuery();

Source: zetcode.com

Similar codes

0 vote142 views1 answer
Mysql master slave setup with keepalived
SQL
0 vote150 views1 answer
Vbscript clean up ADODB.Recordset
SQL
1 vote148 views1 answer
Blob datatype in mysql
SQL
0 vote140 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL
1 vote155 views1 answer
Mysql update inner
SQL
0 vote141 views4 answers
How to connect form to database
SQL
0 vote163 views1 answer
Influxdb list all tags for a measurement
SQL
1 vote142 views1 answer
Select random sample sql
SQL
1 vote129 views1 answer
Delete triger pl pg sql
SQL
0 vote139 views1 answer
SQL isnumeric DB2
SQL