Delete table sqlite

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 vote219 views1 answer
Sql show all users
SQL
0 vote231 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
1 vote207 views2 answers
Mysql spring boot application.properties
SQL
3 votes228 views1 answer
Oracle transaction commit rollback example
SQL
1 vote213 views1 answer
Sql server: difference between hashtable and table declared using declare keyword
SQL
0 vote227 views1 answer
Second Step in installing SQL workbench
SQL
2 votes212 views1 answer
How to make insert script from table in SQL server
SQL
0 vote213 views1 answer
Initcap in sql
SQL
1 vote219 views1 answer
Sql query row number group by
SQL
13 votes246 views3 answers
List all the tables in sql
SQL