MariaDB ALTER TABLE DROP COLUMN infinite

347 views Asked by At

I use below command to drop a column activetime from my table. While this command never end. I waited for 5 mins while there is only 100 records in MY_TABLENAME

ALTER TABLE MY_TABLENAME DROP COLUMN activetime;

The column activetime is defined as below:

| activetime | bigint(20) | NO | | NULL | |

0

There are 0 answers