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

13 votes264 views6 answers
Restart postgresql
SQL
0 vote249 views1 answer
Renommer table sql
SQL
0 vote277 views1 answer
Mariadb datetime change to microseconds
SQL
0 vote264 views1 answer
Sql decode
SQL
0 vote257 views1 answer
Update sqlite
SQL
0 vote276 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL
3 votes250 views2 answers
Mysql add 2 hours
SQL
0 vote256 views1 answer
Ora 00001 error catch plsql
SQL
23 votes286 views4 answers
Uninstall postgresql ubuntu
SQL
3 votes265 views1 answer
Ssh check mysql version
SQL