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

7 votes195 views2 answers
Add column table pl sql
SQL
0 vote197 views1 answer
Oracle free up space in tablespace
SQL
2 votes210 views1 answer
How to show the whole table in sql
SQL
2 votes194 views1 answer
No data found oracle
SQL
0 vote198 views1 answer
Can we rollback deleted data in sql
SQL
5 votes195 views1 answer
Oracle find foreign key dependencies
SQL
0 vote197 views1 answer
Why mysql is used?
SQL
3 votes209 views2 answers
Df to sql pandas sql achemy
SQL
7 votes205 views6 answers
Group_concat mysql
SQL
16 votes228 views6 answers
Mysql find duplicates in same table
SQL