Question : I know it is often asking question. But I can’t find answer for my scenario with specific condition. […]
Tag: drop-table
Can a TRUNCATE or DROP table ever be very time consuming?
Question : A couple of months ago, I discovered in a (not so well maintained) database a totally useless table […]
Speedup DROP huge MySQL replicated table
Question : I’ve a huge InnoDB table customer_users_old (150G) that it’s not in use anymore in the database, it was […]
What is preventing DROP TABLE from removing a Postgres table? [duplicate]
Question : This question already has an answer here: Understanding psql prompts (1 answer) Closed 6 years ago. I have […]
Allow user to drop only tables / views created by that user in MySQL
Question : Is it possible to allow a user to only drop tables and views that he/she created in MySQL? […]
Massive DROP on a production database with the shortest downtime
Question : I was redesigning legacy database and have merged lots of tables into just four and now I’m looking […]
Allow user to drop only tables / views created by that user in MySQL
Question : Is it possible to allow a user to only drop tables and views that he/she created in MySQL? […]
Replacing MYSQL table with data from another table – no downtime
Question : I have two tables with identical structures: Table1 and Table2 id INT PRIMARY KEY, a TINYINT, b TINYINT, […]
Speed difference between Drop table and Truncate table in Postgres
Question : I currently have a program that inserts into a database by creating temp tables, filling the tables, then […]
How to check foreign keys related to a table
Question : How to see foreign keys related to a table in MySql? Background : I wanted to drop a […]