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

1 vote199 views1 answer
Check if mysql is installed
SQL
2 votes206 views1 answer
Sql find not in list
SQL
2 votes192 views2 answers
Get all tables using like
SQL
5 votes190 views1 answer
Ascending order and where in sql
SQL
12 votes198 views4 answers
How to take database dump in postgresql
SQL
2 votes177 views1 answer
Plsql block
SQL
0 vote195 views1 answer
Modificar tipo de dato sql server
SQL
6 votes189 views2 answers
Database url postgres
SQL
1 vote203 views1 answer
Select tables with name like mysql
SQL
4 votes195 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL