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

2 votes280 views3 answers
How to replace null values in sql
SQL
15 votes224 views2 answers
Sql order by multiple columns
SQL
13 votes247 views2 answers
Oracle select into and inner join
SQL
0 vote253 views3 answers
Join
SQL
1 vote236 views1 answer
Show all event schedular on mysql
SQL
-1 vote230 views1 answer
Io
SQL
8 votes271 views2 answers
Update sql server from another table
SQL
13 votes223 views5 answers
Oracle list tables
SQL
3 votes235 views2 answers
Current year sql
SQL
0 vote267 views1 answer
Mysql grant all on all databases
SQL