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 vote282 views1 answer
Sql count null values in all columns
SQL
2 votes274 views1 answer
Q operator in sql
SQL
0 vote255 views1 answer
Recursive query herarchical data sql server
SQL
12 votes267 views1 answer
Docker mysql random root password
SQL
0 vote256 views1 answer
Myswql show full processlist
SQL
1 vote265 views1 answer
Import in mysql without a software
SQL
1 vote279 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL
0 vote309 views1 answer
Oracle chain step succeeded
SQL
4 votes271 views3 answers
Order by value mysql
SQL
0 vote275 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL