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

52 votes541 views6 answers
Rename column sql
SQL
0 vote311 views1 answer
Hex string sql becomes int64
SQL
0 vote302 views1 answer
Default password for mysql_secure_installation in mac
SQL
2 votes299 views1 answer
Oracle trace session
SQL
5 votes317 views1 answer
Get table columns from sql
SQL
2 votes298 views1 answer
Sql server find table name
SQL
2 votes329 views1 answer
Merge firstname and lastname in sql oracle
SQL
2 votes310 views1 answer
Oracle calculated column
SQL
13 votes288 views2 answers
Sqlite rename column
SQL
0 vote317 views3 answers
How to run sql query
SQL