Delete table sqlite

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
How to put value in parameters in mysqldataadapter
SQL
4 votes142 views1 answer
Mysql ip address
SQL
0 vote183 views5 answers
How to make trigger in phpmyadmin
SQL
6 votes146 views3 answers
Oracle all dates between two dates
SQL
10 votes151 views4 answers
SELECT FROM WHERE
SQL
0 vote162 views1 answer
Sql server current time without date
SQL
0 vote180 views1 answer
How to check event scheduler status mysql
SQL
0 vote153 views1 answer
Sql select column name like from multiple tables
SQL
0 vote179 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
0 vote168 views1 answer
Sql basic commands
SQL