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

28 votes236 views6 answers
Sql update
SQL
0 vote211 views1 answer
Mysql function variable
SQL
1 vote217 views1 answer
Last 6 months postgresql
SQL
3 votes221 views3 answers
C# sql select
SQL
10 votes216 views1 answer
Create table oracle
SQL
2 votes223 views1 answer
Sql percentage with % rounded down
SQL
0 vote217 views1 answer
Recently updated stored procedure in sql server
SQL
5 votes229 views3 answers
Oracle first day of last year
SQL
0 vote228 views1 answer
Sql join on a subquery
SQL
1 vote219 views1 answer
Drop function
SQL