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 vote141 views1 answer
Sql get missing id
SQL
0 vote182 views1 answer
Mysql faster delete
SQL
1 vote115 views1 answer
Oracle compile schema
SQL
2 votes151 views1 answer
Sql server find columns list in tables
SQL
0 vote130 views1 answer
Oracle gather table statistics
SQL
1 vote130 views1 answer
Select statement to print longest name
SQL
0 vote158 views1 answer
Executescalar in sql server
SQL
1 vote147 views1 answer
Mysql select from outside
SQL
150 votes325 views10 answers
Grepper
SQL
1 vote146 views1 answer
Tsql replace value in json
SQL