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 vote284 views1 answer
Mysql range of dates overlap
SQL
5 votes273 views4 answers
Select random rows sql
SQL
3 votes292 views1 answer
Postgresql today - 1 year
SQL
0 vote277 views1 answer
Oracle activate program
SQL
0 vote271 views1 answer
How to define a save method in ruby for sql databases
SQL
1 vote269 views1 answer
Oracle sql assign unique number to each grouping
SQL
3 votes271 views5 answers
ModuleNotFoundError: No module named 'MySQLdb'
SQL
0 vote356 views2 answers
Insert data into multiple tables mysql
SQL
50 votes346 views6 answers
Install mysql on ubuntu
SQL
0 vote273 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL