Question : I have a table in my SQL Server that’s called “Regions”, it has information about 9 regions and […]
Tag: alter-table
Error parsing DDL for schema.table in mysql workbench
Question : I have production dbs using Mysql 5.5.31-0ubuntu0.12.04-1 (I know its old, will be upgraded soon). I used a […]
Amazon Postgres RDS: Update pg_attribute to update my custom attribute
Question : I want to update my attribute to change its length. I am getting Error: Permission denied for relation […]
Truncating table without using Alter Table permission
Question : So my DBA doesn’t want developers to give Alter table permission. Now one of the procedures that we […]
Altering CHAR(n BYTE) Column
Question : How to change CHAR (17 byte) to CHAR (16 byte) when there is already a data? Values are […]
Memory Optimized Tables – can they really be so difficult to maintain?
Question : I’m investigating the benefits of upgrading from MS SQL 2012 to 2014. One of the big selling points […]
Query Performance When Dropping Multiple Columns
Question : In PostgreSQL, is there any performance gain when using a single ALTER TABLE statement to drop multiple columns, […]
Add NOT NULL constraint to large table without table scan [duplicate]
Question : This question already has answers here: Does PostgreSQL optimize adding columns with non-NULL DEFAULTs? (2 answers) Closed 3 […]
How to change all columns from one type to another, changing all FK columns as well?
Question : In an inherited DB we found that there are around 25 tables with a primary key defined as […]
Why does simple ALTER TABLE command take so long on table with full-text index?
Question : I have a large (~67 million rows) name-value table that has full-text indexing on the DataValue column. If […]