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 vote222 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
3 votes239 views2 answers
Mysql config user password
SQL
0 vote230 views1 answer
Jooq replace
SQL
0 vote214 views1 answer
Count column of tables psql
SQL
0 vote256 views1 answer
Update sql sintax
SQL
0 vote241 views2 answers
How to delete the rows with null values in mysql
SQL
0 vote251 views1 answer
How we can perform acid Operations in sql with examples
SQL
0 vote219 views2 answers
Mysql get routine parameter list
SQL
1 vote229 views1 answer
Sql get missing id
SQL
0 vote256 views1 answer
SQL Cut part string
SQL