Delete table sqlite

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

7 votes338 views1 answer
Mysql unsafe update
SQL
6 votes386 views2 answers
How to get yesterday date in mysql
SQL
5 votes386 views1 answer
Oracle asynchronous update
SQL
0 vote379 views1 answer
Mysql get last 2 month data
SQL
3 votes428 views3 answers
Update con select postgresql
SQL
0 vote369 views1 answer
Name '_mysql' is not defined
SQL
0 vote323 views1 answer
How to get last client id sql
SQL
2 votes375 views2 answers
Install postgresql
SQL
6 votes348 views2 answers
Mysql version check cmd
SQL
0 vote347 views1 answer
Google sheets filter rows above current cell
SQL