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 vote267 views1 answer
Call function sql oracle with output put line
SQL
0 vote266 views1 answer
TSQL function split string
SQL
45 votes342 views5 answers
Grant all privileges mysql
SQL
2 votes265 views2 answers
Compare date mysql
SQL
0 vote266 views1 answer
Sql query interview questions githu
SQL
31 votes275 views4 answers
How to get duplicate records with multiple field in sql
SQL
3 votes266 views1 answer
Ms sql skip take
SQL
5 votes246 views2 answers
Create table
SQL
3 votes262 views2 answers
Sqlite show table definition
SQL
3 votes296 views1 answer
Create a table with an id in mysql
SQL