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

0 vote136 views1 answer
Grepper sql workbench download
SQL
0 vote168 views1 answer
How to find unique element in sql
SQL
37 votes144 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
0 vote180 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
9 votes135 views3 answers
Mysql get last id
SQL
0 vote150 views1 answer
Mysql default tls v1.3 ciphersuites
SQL
0 vote93 views1 answer
How to see the content of tables in pgadmin
SQL
13 votes131 views2 answers
Check if value is null mysql
SQL
16 votes141 views6 answers
Install sqlite3 python
SQL
0 vote146 views1 answer
Sql doesn't contain
SQL