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

0 vote148 views1 answer
Hibernate with springboot mysql
SQL
0 vote174 views1 answer
Mysql bind-address default value
SQL
1 vote172 views1 answer
Error cs1061 'dbcontextoptionsbuilder' does not contain a definition for 'usesqlserver'
SQL
0 vote144 views1 answer
Hibernate dialect property xml for mysql 8
SQL
10 votes143 views2 answers
Tsql merge example
SQL
11 votes145 views2 answers
Docker create postgres db
SQL
1 vote142 views2 answers
ImportError: No module named mysql.connector
SQL
1 vote156 views1 answer
Oracle create index if not exists
SQL
1 vote140 views1 answer
How to open closed port mysql in ubuntu
SQL
2 votes142 views1 answer
Oracle drop table free up space
SQL