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 vote406 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
0 vote367 views1 answer
Search mysql database for column
SQL
1 vote389 views1 answer
Update from table tsql
SQL
3 votes373 views2 answers
Install mysql powershell
SQL
0 vote341 views2 answers
Mysql output csv
SQL
0 vote428 views1 answer
Mssql last day of month
SQL
1 vote362 views1 answer
Failed to stop mysqld.service: Unit mysqld.service not loaded.
SQL
0 vote401 views1 answer
How to fetch data from database in sql
SQL
0 vote347 views1 answer
Google sheets filter rows above current cell
SQL
0 vote429 views1 answer
Oracle calculate statistics on partition
SQL