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

14 votes149 views4 answers
Sql compiler
SQL
1 vote99 views1 answer
Mssql string length
SQL
1 vote200 views1 answer
Connect to mysql database ubuntu
SQL
3 votes144 views4 answers
Show sql server database
SQL
0 vote170 views1 answer
Trigger stock phpmyadmin
SQL
0 vote143 views1 answer
Mysql where don't have string
SQL
4 votes139 views1 answer
Add constraint fk
SQL
0 vote146 views1 answer
Mysql date format unix timestamp
SQL
9 votes150 views5 answers
Sql limit
SQL
2 votes144 views1 answer
Change primary key sql
SQL