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

1 vote218 views1 answer
Postgres format date in select
SQL
2 votes255 views2 answers
Sql lag
SQL
1 vote244 views1 answer
How to fetch data in between startfromdate to starenddate in sql
SQL
9 votes215 views3 answers
Sequence postgresql
SQL
0 vote225 views1 answer
Sql server size of every table in a db
SQL
3 votes257 views5 answers
Sql select
SQL
5 votes213 views2 answers
Ranking functions in sql
SQL
0 vote251 views1 answer
Insert value in identity
SQL
0 vote236 views1 answer
Primary key multiple colums
SQL
1 vote219 views1 answer
How to check the mysql version mac
SQL