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

2 votes298 views3 answers
Row number mysql
SQL
8 votes305 views1 answer
Mysql dump restore
SQL
0 vote267 views1 answer
Raven ql select count
SQL
14 votes277 views5 answers
Sql oracle limit
SQL
0 vote260 views1 answer
Dnsmasq.conf location macos
SQL
0 vote282 views1 answer
Php mysqli install
SQL
0 vote272 views1 answer
Mysql calculated column
SQL
2 votes268 views2 answers
How to create an empty table from an existing table
SQL
15 votes261 views4 answers
How to get all tables in sql
SQL
1 vote265 views2 answers
Datetrunc hour snowflake
SQL