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

6 votes261 views5 answers
Sql add months to date
SQL
27 votes276 views5 answers
Mysql set password for user
SQL
2 votes248 views1 answer
Check isolation level in mysql
SQL
0 vote257 views1 answer
Add computed column to table sql server
SQL
0 vote262 views1 answer
Group by max date
SQL
0 vote230 views1 answer
Duplicate foreign key constraint name
SQL
0 vote254 views1 answer
Mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z
SQL
0 vote253 views2 answers
Auto increment column in mysql query results
SQL
0 vote266 views1 answer
Postgresql concat string with separator
SQL
1 vote236 views1 answer
Can we drop a primary key
SQL