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 vote314 views1 answer
Concat first name and last name in mysql
SQL
17 votes282 views2 answers
Mysql date to string
SQL
7 votes300 views1 answer
Query postgres delete duplicates
SQL
11 votes249 views1 answer
Reset identity sql server
SQL
3 votes280 views1 answer
Pl sql escape &
SQL
3 votes276 views3 answers
Create table in microsoft sql server
SQL
3 votes319 views2 answers
Wp do sql query from function
SQL
0 vote291 views1 answer
Sql put two columns into one
SQL
0 vote295 views1 answer
Excel vba import data to sql server
SQL
0 vote278 views1 answer
Mysql Like(searching in the string)
SQL