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

7 votes171 views2 answers
Create index mysql
SQL
4 votes192 views3 answers
NOT NULL SQL
SQL
0 vote173 views1 answer
Sql select upcoming birthdays
SQL
0 vote169 views1 answer
Mysql to get column name in database
SQL
8 votes187 views1 answer
Mysql restore database
SQL
0 vote168 views1 answer
Mysql_num_fields in mysqli
SQL
0 vote169 views1 answer
Update table sql multiple set
SQL
2 votes182 views1 answer
ADD COLOUNS CREATED AND UPDATED AT IN MYSQL
SQL
0 vote162 views1 answer
Oracle index hint
SQL
5 votes162 views1 answer
Sqlite alter table add column
SQL