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

12 votes230 views1 answer
Env var for setting password for root user mysql docker hub
SQL
0 vote201 views1 answer
Commit transaction sql
SQL
7 votes177 views1 answer
Alter table add key sql
SQL
0 vote197 views1 answer
Postgresql remove duplicate rows 2 columns
SQL
0 vote192 views1 answer
NLS_NCHAR_CHARACTERSET
SQL
0 vote240 views1 answer
Get create sql of hibernqte entity
SQL
3 votes262 views2 answers
Brew restart mysql
SQL
1 vote280 views1 answer
Postgres select as csv
SQL
4 votes208 views1 answer
Oracle error line
SQL
0 vote227 views1 answer
Hashpass
SQL