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 vote151 views5 answers
Mode sql course
SQL
1 vote145 views1 answer
Mysql show table character set
SQL
14 votes161 views1 answer
Oracle alter table add column not null
SQL
2 votes200 views1 answer
Oracle Column Names of a table
SQL
1 vote152 views1 answer
Access the postgres psql
SQL
1 vote151 views1 answer
Oracle list constraints
SQL
3 votes206 views3 answers
List columns in table postgres
SQL
2 votes144 views2 answers
Exec procedure pl sql
SQL
0 vote149 views1 answer
Postgres drop type
SQL
0 vote152 views2 answers
Database owner can't create new tables postgres
SQL