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 vote296 views1 answer
Add user mysql wordpress
SQL
12 votes250 views10 answers
Google
SQL
1 vote218 views1 answer
Sql select max value from multiple rows
SQL
4 votes219 views1 answer
Ms sql truncate table vs delete
SQL
0 vote187 views1 answer
Commit transaction sql
SQL
2 votes205 views1 answer
Node and mysql like
SQL
0 vote196 views2 answers
How to count codition
SQL
0 vote193 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL
2 votes193 views2 answers
Select list is not in group by clause
SQL
3 votes186 views1 answer
Oracle list user grants
SQL