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 vote198 views1 answer
Php mysqli install
SQL
1 vote205 views1 answer
Oracle create program if no exists
SQL
0 vote152 views1 answer
Calculate discount from original price sql
SQL
0 vote267 views1 answer
Example of sql querry result sepapreted by comma
SQL
0 vote261 views1 answer
Convert rows into columns in oracle
SQL
0 vote188 views1 answer
How to start my sql server on mac
SQL
1 vote206 views2 answers
Oracle list partitioned tables
SQL
1 vote188 views1 answer
How to delete data from sql database in android
SQL
4 votes186 views1 answer
Mysql copy table with new name
SQL
0 vote200 views1 answer
Write sql query to show the details start from digit
SQL