Running DROP statements in production is always dangerous. But there are some measures we can take to make them safer.
MySQL
In MariaDB and MySQL, all tables should have a primary key – especially InnoDB tables. Here's why.
Updating triggers in production without causing a service disruption
It is possible to prevent some users from seeing a set of rows in a certain table.
Vettabase specialises in expert consulting and automation for your database infrastructure. We offer professional services and training for MySQL, MariaDB, PostgreSQL and Cassandra.