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

2 votes210 views2 answers
Mysql alter column default
SQL
5 votes216 views4 answers
Start postgres server
SQL
0 vote191 views1 answer
Query on date sqlite flutter
SQL
26 votes204 views2 answers
Mysql workbench download
SQL
0 vote206 views1 answer
Compression of dabatase mysqldumo
SQL
0 vote202 views1 answer
Java sql timestamp now
SQL
-1 vote192 views1 answer
Search all database tables for a value sqlserver
SQL
-1 vote194 views3 answers
Update mongodb version ubuntu
SQL
0 vote199 views2 answers
Mysql multiply
SQL
13 votes224 views2 answers
Oracle inner join
SQL