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

17 votes178 views6 answers
Sql select distinct
SQL
0 vote178 views1 answer
Https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
SQL
1 vote234 views1 answer
Varchar plsql
SQL
16 votes245 views4 answers
Find duplicates mysql
SQL
1 vote178 views1 answer
Oracle list datafiles in tablespace
SQL
0 vote315 views1 answer
Android sqlite add column if not exists
SQL
0 vote214 views1 answer
Sqlite unique multiple columns
SQL
0 vote196 views1 answer
Add mysql database to power bi web
SQL
0 vote181 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
10 votes205 views6 answers
Sql between
SQL