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 vote344 views2 answers
How to check username in mysql command line
SQL
-1 vote380 views1 answer
Mysql faster insert
SQL
1 vote347 views2 answers
How to enable error squiggles in vs code
SQL
8 votes354 views4 answers
How to calculate the age from date of birth in python
SQL
1 vote361 views3 answers
Java.sql.sqlexception: access denied for user
SQL
14 votes406 views6 answers
Finding duplicate rows mysql
SQL
0 vote362 views1 answer
Oracle dynamic select into
SQL
0 vote386 views1 answer
Oracle exchange subpartition
SQL
7 votes341 views3 answers
Postgre describe table
SQL
0 vote379 views1 answer
Modifier une valeur sql
SQL