Questions tagged [drop-table]
This tag is for the SQL command DROP TABLE
9
questions with no upvoted or accepted answers
2
votes
0answers
53 views
Is it possible to drop inheritance from the parent table (top down)?
Our system uses inheritance on two levels:
master
child_level_1
child_level_2
child_level_2
child_level_2
child_level_1
child_level_2
child_level_2
child_level_1
child_level_2
The idea was to ...
2
votes
1answer
106 views
Proper Way to Remove Mysql Tables
I was going to ask why mysqldump was trying to write dropped tables but I found that answer from this question, How do you remove reported non existing tables from mysql?.
Removing the .frm files ...
2
votes
1answer
2k views
Reclaim disk space after dropping table(innodb_file_per_table = ON), strange scenario
I know it is often asking question. But I can't find answer for my scenario with specific condition.
We use MySQL 5.5
We have always(I am sure)
innodb_file_per_table = ON
option in our mysql ...
1
vote
1answer
386 views
drop table causes ORA-08103 with another one
In my process I have 2 tables.
target table, load table.
The target table holds the current data, and a lot of queries are fired against it.
When new data coming we use a FULL LOAD and the goal ...
1
vote
2answers
157 views
Replacing MYSQL table with data from another table - no downtime
I have two tables with identical structures:
Table1 and Table2
id INT PRIMARY KEY,
a TINYINT,
b TINYINT,
c TINYINT
Table1 is actively being used by queries from other sessions; Table2 is not ...
1
vote
0answers
20 views
Delete datafile from parttioned table
I'm used SQL Server 2014.
My big table partitioned by date column and each partition has own datafile.
I want delete oldest partition data and data file too.
How to do it?
0
votes
0answers
47 views
Azure SQL DB: Can't create table because it already exists, can't drop or write to table because it doesn't exist
I have an Azure SQL DB database that I am copying data into from a source database using SSIS. My SSIS package for one table fails because it can't write to or create a specific table name (it is ...
0
votes
1answer
412 views
Trigger to drop table only if there are no records
How do I write a DDL DROP_TABLE trigger that will only drop the table if there are no records?
0
votes
1answer
321 views
Why we can FLASHBACK DROP table where it is DDL command and hence autocommited?
DROP and TRUNCATE both are DDL commands and both are autocommited.Then why we can recover DROP table by using FLASHBACK(unless it is purge) and why we can not recover TRUNCATED data(don't consider ...
