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

5 votes223 views2 answers
Get columns number sql
SQL
0 vote212 views1 answer
Mysql get last 2 month data
SQL
1 vote209 views1 answer
How to set up a trigger in sql
SQL
0 vote219 views1 answer
Sql script to remove default from column
SQL
0 vote199 views1 answer
Psql initialization
SQL
1 vote189 views1 answer
Stop mysql server mac
SQL
0 vote219 views1 answer
Sql doesn't contain
SQL
3 votes206 views1 answer
Kill mysql processlist in whose time more than 200
SQL
3 votes208 views3 answers
How to set up an auto incrementing id db browser
SQL
0 vote276 views2 answers
Uninstall postgresql mac
SQL