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 vote152 views1 answer
Mysql get max value and id
SQL
0 vote150 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL
3 votes208 views2 answers
Mysql user permission database
SQL
5 votes149 views1 answer
Sql add column after another
SQL
0 vote144 views1 answer
Delete insert record in sql server
SQL
0 vote181 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
0 vote142 views1 answer
Postgresql update to unique
SQL
1 vote144 views1 answer
Sql exclude duplicates and find even id
SQL
1 vote157 views1 answer
Postgresql can you have null foreign key
SQL
1 vote140 views1 answer
Sql restore backup query
SQL