Working on custom extension and need to implement ENUM datatype.

In Magento1, we use to implement in this way,

ALTER TABLE `{$this->getTable('catalog_product_option_type_price')}` CHANGE `price_type` `price_type` ENUM( 'fixed', 'percent', 'absolute' ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'fixed' 

How to make this work for Magento2?

  • You can do same way in M2.
    – Sohel Rana
    Aug 6, 2016 at 15:26

1 Answer 1


It's (ENUM datatype) not supported in Magento 2

You can get more info from @ Igor Minyaylo answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.