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

1 vote132 views1 answer
Clear screen command in psql
SQL
1 vote153 views1 answer
Select not matching data with join table
SQL
2 votes164 views1 answer
Oracle insert or update
SQL
7 votes120 views3 answers
Add primary key to database sql
SQL
28 votes124 views4 answers
Show tables mysql
SQL
1 vote133 views1 answer
Second last highest id in sql
SQL
11 votes119 views1 answer
Oracle insert into where
SQL
3 votes212 views2 answers
Savepoint in sql
SQL
3 votes135 views1 answer
Kill mysql processlist in whose time more than 200
SQL
0 vote132 views1 answer
Contact mysql column field
SQL