Top "Drop-table" questions

The SQL command for deleting an entire table.

Create table but Drop it if the table exists already

I am working on a request where I have to create a table to insert some data. So, obviously I …

sql teradata create-table drop-table
Android SQLite Database, WHY drop table and recreate on upgrade

In the tutorials I am following and a lot of more places I see this, onUpgrade -> drop table …

android database sqlite database-update drop-table
How to drop all tables in database without dropping the database itself?

I would like to delete all the tables from database, but not deleting the database itself. Is it possible ? I'm …

php sql mysql drop-table
Dropping a table in SAS

What is the most efficient way to drop a table in SAS? I have a program that loops and drops …

sas proc-sql drop-table
Hive: DROP TABLE IF EXISTS <Table Name> does not free memory

When I am using DROP TABLE IF EXISTS <Table Name> in hive, it is not freeing the memory. …

hive drop-table
Drop temporary table when exiting a function

I use a temp table in a function with the 'on commit drop' option. My problem is, in certain cases, …

database postgresql drop-table
Cannot drop a mysql table

I am getting a weird error. I have a table animals, that I am trying to drop. I cannot drop …

mysql sql sqlyog drop-table
SQL Server: Does 'DROP TABLE' inside transaction causes an implicit commit?

My question is kind of easy but i'm still doubting after I created this transaction. If I execute the following …

sql transactions drop-table
mysql drop table and cascade delete to all references to the table

I'm developing a new system from an old system. The new system is using MySQL and java. I want to …

mysql drop-table
Drop MySQL table using Liquibase

I am looking to drop a table in MySQL using Liquibase only if the table exists. I am not able …

java mysql database liquibase drop-table