Ggtkuk

Is there a difference between "Fahrstuhl" and "Aufzug"?

Does Germany produce more waste than the US?

how one can write a nice vector parser, something that does pgfvecparseA=B-C; D=E x F;

Audio Conversion With ADS1243

Are the names of these months realistic?

Is it correct to say moon starry nights?

Where do students learn to solve polynomial equations these days?

What would be the main consequences for a country leaving the WTO?

Traveling with my 5 year old daughter (as the father) without the mother from Germany to Mexico

Can Sneak Attack be used when hitting with an improvised weapon?

Point distance program written without a framework

Man transported from Alternate World into ours by a Neutrino Detector

How did Beeri the Hittite come up with naming his daughter Yehudit?

Airplane gently rocking its wings during whole flight

Help/tips for a first time writer?

what's the use of '% to gdp' type of variables?

Why is the US ranked as #45 in Press Freedom ratings, despite its extremely permissive free speech laws?

Yu-Gi-Oh cards in Python 3

Reference request: Grassmannian and Plucker coordinates in type B, C, D

What CSS properties can the br tag have?

Is there an equivalent of cd - for cp or mv

"Eavesdropping" vs "Listen in on"

free fall ellipse or parabola?

Do scriptures give a method to recognize a truly self-realized person/jivanmukta?

In Magento 2 - How to remove a column in customer_entity table?

7

1

In Magento 2, How to remove a column in customer_entity table?

magento2 customer

share|improve this question

edited Mar 19 at 7:45

magefms

2,1352426

asked Dec 30 '16 at 8:14

MrTo-KaneMrTo-Kane

1,78162465

add a comment | 

7

1

In Magento 2, How to remove a column in customer_entity table?

magento2 customer

share|improve this question

edited Mar 19 at 7:45

magefms

2,1352426

asked Dec 30 '16 at 8:14

MrTo-KaneMrTo-Kane

1,78162465

add a comment | 

In Magento 2, How to remove a column in customer_entity table?

magento2 customer

share|improve this question

edited Mar 19 at 7:45

magefms

2,1352426

asked Dec 30 '16 at 8:14

MrTo-KaneMrTo-Kane

1,78162465

share|improve this question

edited Mar 19 at 7:45

magefms

2,1352426

asked Dec 30 '16 at 8:14

MrTo-KaneMrTo-Kane

1,78162465

share|improve this question

edited Mar 19 at 7:45

magefms

2,1352426

asked Dec 30 '16 at 8:14

MrTo-KaneMrTo-Kane

1,78162465

edited Mar 19 at 7:45

magefms

2,1352426

edited Mar 19 at 7:45

magefms

2,1352426

asked Dec 30 '16 at 8:14

MrTo-KaneMrTo-Kane

1,78162465

asked Dec 30 '16 at 8:14

MrTo-KaneMrTo-Kane

1,78162465

3 Answers
3

active

oldest

votes

13

In your setup script, we can use dropColumn:

 $setup->getConnection()->dropColumn($setup->getTable('your_table'), 'your_column');

share|improve this answer

answered Dec 30 '16 at 8:21

Khoa TruongDinhKhoa TruongDinh

22k64187

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  doing with UpgradeSchema.php is a better and cleaner solution
  
  – Blueblazer172
  Oct 9 '17 at 12:39
  

  
  
  
  

add a comment | 

5

You can try this simple dropColumn() function in your installer script.

$this->startSetup();

//example: 
$this->getConnection()->dropColumn($this->getTable('your_table_definition'), 'your column name', $schemaName = null)

$this->endSetup();

share|improve this answer

edited Dec 30 '16 at 8:35

answered Dec 30 '16 at 8:22

chiragchirag

2,1421830

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  thank your answer!
  
  – MrTo-Kane
  Dec 30 '16 at 8:40
  

  
  
  
  

add a comment | 

5

Here is my solution, maybe good for referring for other.

I created TohqCustomerSetupUpgradeSchema.php file:

<?php

namespace TohqCustomerSetup;

use MagentoFrameworkSetupUpgradeSchemaInterface;
use MagentoFrameworkSetupModuleContextInterface;
use MagentoFrameworkSetupSchemaSetupInterface;

/**
 * @codeCoverageIgnore
 */
class UpgradeSchema implements UpgradeSchemaInterface

 public function upgrade(SchemaSetupInterface $setup, ModuleContextInterface $context)
 
 // Version of module in setup table is less then the give value.
 if (version_compare($context->getVersion(), '0.1.4', '<')) 

 // get table customer_entity
 $eavTable = $setup->getTable('customer_entity');

 // Check if the table already exists
 if ($setup->getConnection()->isTableExists($eavTable) == true) 
 $connection = $setup->getConnection();

 // del_flg = column name which you want to delete
 $connection->dropColumn($eavTable, 'del_flg');
 
 

 

share|improve this answer

edited Mar 30 '18 at 12:18

Kanhaiya lal

880417

answered Dec 30 '16 at 8:46

MrTo-KaneMrTo-Kane

1,78162465

add a comment | 

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f152484%2fin-magento-2-how-to-remove-a-column-in-customer-entity-table%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

13

In your setup script, we can use dropColumn:

 $setup->getConnection()->dropColumn($setup->getTable('your_table'), 'your_column');

share|improve this answer

answered Dec 30 '16 at 8:21

Khoa TruongDinhKhoa TruongDinh

22k64187

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  doing with UpgradeSchema.php is a better and cleaner solution
  
  – Blueblazer172
  Oct 9 '17 at 12:39
  

  
  
  
  

add a comment | 

13

In your setup script, we can use dropColumn:

 $setup->getConnection()->dropColumn($setup->getTable('your_table'), 'your_column');

share|improve this answer

answered Dec 30 '16 at 8:21

Khoa TruongDinhKhoa TruongDinh

22k64187

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  doing with UpgradeSchema.php is a better and cleaner solution
  
  – Blueblazer172
  Oct 9 '17 at 12:39
  

  
  
  
  

add a comment | 

In your setup script, we can use dropColumn:

 $setup->getConnection()->dropColumn($setup->getTable('your_table'), 'your_column');

share|improve this answer

answered Dec 30 '16 at 8:21

Khoa TruongDinhKhoa TruongDinh

22k64187

 $setup->getConnection()->dropColumn($setup->getTable('your_table'), 'your_column');

share|improve this answer

answered Dec 30 '16 at 8:21

Khoa TruongDinhKhoa TruongDinh

22k64187

answered Dec 30 '16 at 8:21

Khoa TruongDinhKhoa TruongDinh

22k64187

answered Dec 30 '16 at 8:21

Khoa TruongDinhKhoa TruongDinh

22k64187

5

You can try this simple dropColumn() function in your installer script.

$this->startSetup();

//example: 
$this->getConnection()->dropColumn($this->getTable('your_table_definition'), 'your column name', $schemaName = null)

$this->endSetup();

share|improve this answer

edited Dec 30 '16 at 8:35

answered Dec 30 '16 at 8:22

chiragchirag

2,1421830

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  thank your answer!
  
  – MrTo-Kane
  Dec 30 '16 at 8:40
  

  
  
  
  

add a comment | 

5

You can try this simple dropColumn() function in your installer script.

$this->startSetup();

//example: 
$this->getConnection()->dropColumn($this->getTable('your_table_definition'), 'your column name', $schemaName = null)

$this->endSetup();

share|improve this answer

edited Dec 30 '16 at 8:35

answered Dec 30 '16 at 8:22

chiragchirag

2,1421830

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  thank your answer!
  
  – MrTo-Kane
  Dec 30 '16 at 8:40
  

  
  
  
  

add a comment | 

You can try this simple dropColumn() function in your installer script.

$this->startSetup();

//example: 
$this->getConnection()->dropColumn($this->getTable('your_table_definition'), 'your column name', $schemaName = null)

$this->endSetup();

share|improve this answer

edited Dec 30 '16 at 8:35

answered Dec 30 '16 at 8:22

chiragchirag

2,1421830

$this->startSetup();

//example: 
$this->getConnection()->dropColumn($this->getTable('your_table_definition'), 'your column name', $schemaName = null)

$this->endSetup();

share|improve this answer

edited Dec 30 '16 at 8:35

answered Dec 30 '16 at 8:22

chiragchirag

2,1421830

answered Dec 30 '16 at 8:22

chiragchirag

2,1421830

answered Dec 30 '16 at 8:22

chiragchirag

2,1421830

5

Here is my solution, maybe good for referring for other.

I created TohqCustomerSetupUpgradeSchema.php file:

<?php

namespace TohqCustomerSetup;

use MagentoFrameworkSetupUpgradeSchemaInterface;
use MagentoFrameworkSetupModuleContextInterface;
use MagentoFrameworkSetupSchemaSetupInterface;

/**
 * @codeCoverageIgnore
 */
class UpgradeSchema implements UpgradeSchemaInterface

 public function upgrade(SchemaSetupInterface $setup, ModuleContextInterface $context)
 
 // Version of module in setup table is less then the give value.
 if (version_compare($context->getVersion(), '0.1.4', '<')) 

 // get table customer_entity
 $eavTable = $setup->getTable('customer_entity');

 // Check if the table already exists
 if ($setup->getConnection()->isTableExists($eavTable) == true) 
 $connection = $setup->getConnection();

 // del_flg = column name which you want to delete
 $connection->dropColumn($eavTable, 'del_flg');
 
 

 

share|improve this answer

edited Mar 30 '18 at 12:18

Kanhaiya lal

880417

answered Dec 30 '16 at 8:46

MrTo-KaneMrTo-Kane

1,78162465

add a comment | 

5

Here is my solution, maybe good for referring for other.

I created TohqCustomerSetupUpgradeSchema.php file:

<?php

namespace TohqCustomerSetup;

use MagentoFrameworkSetupUpgradeSchemaInterface;
use MagentoFrameworkSetupModuleContextInterface;
use MagentoFrameworkSetupSchemaSetupInterface;

/**
 * @codeCoverageIgnore
 */
class UpgradeSchema implements UpgradeSchemaInterface

 public function upgrade(SchemaSetupInterface $setup, ModuleContextInterface $context)
 
 // Version of module in setup table is less then the give value.
 if (version_compare($context->getVersion(), '0.1.4', '<')) 

 // get table customer_entity
 $eavTable = $setup->getTable('customer_entity');

 // Check if the table already exists
 if ($setup->getConnection()->isTableExists($eavTable) == true) 
 $connection = $setup->getConnection();

 // del_flg = column name which you want to delete
 $connection->dropColumn($eavTable, 'del_flg');
 
 

 

share|improve this answer

edited Mar 30 '18 at 12:18

Kanhaiya lal

880417

answered Dec 30 '16 at 8:46

MrTo-KaneMrTo-Kane

1,78162465

add a comment | 

Here is my solution, maybe good for referring for other.

I created TohqCustomerSetupUpgradeSchema.php file:

<?php

namespace TohqCustomerSetup;

use MagentoFrameworkSetupUpgradeSchemaInterface;
use MagentoFrameworkSetupModuleContextInterface;
use MagentoFrameworkSetupSchemaSetupInterface;

/**
 * @codeCoverageIgnore
 */
class UpgradeSchema implements UpgradeSchemaInterface

 public function upgrade(SchemaSetupInterface $setup, ModuleContextInterface $context)
 
 // Version of module in setup table is less then the give value.
 if (version_compare($context->getVersion(), '0.1.4', '<')) 

 // get table customer_entity
 $eavTable = $setup->getTable('customer_entity');

 // Check if the table already exists
 if ($setup->getConnection()->isTableExists($eavTable) == true) 
 $connection = $setup->getConnection();

 // del_flg = column name which you want to delete
 $connection->dropColumn($eavTable, 'del_flg');
 
 

 

share|improve this answer

edited Mar 30 '18 at 12:18

Kanhaiya lal

880417

answered Dec 30 '16 at 8:46

MrTo-KaneMrTo-Kane

1,78162465

<?php

namespace TohqCustomerSetup;

use MagentoFrameworkSetupUpgradeSchemaInterface;
use MagentoFrameworkSetupModuleContextInterface;
use MagentoFrameworkSetupSchemaSetupInterface;

/**
 * @codeCoverageIgnore
 */
class UpgradeSchema implements UpgradeSchemaInterface

 public function upgrade(SchemaSetupInterface $setup, ModuleContextInterface $context)
 
 // Version of module in setup table is less then the give value.
 if (version_compare($context->getVersion(), '0.1.4', '<')) 

 // get table customer_entity
 $eavTable = $setup->getTable('customer_entity');

 // Check if the table already exists
 if ($setup->getConnection()->isTableExists($eavTable) == true) 
 $connection = $setup->getConnection();

 // del_flg = column name which you want to delete
 $connection->dropColumn($eavTable, 'del_flg');
 
 

 

share|improve this answer

edited Mar 30 '18 at 12:18

Kanhaiya lal

880417

answered Dec 30 '16 at 8:46

MrTo-KaneMrTo-Kane

1,78162465

edited Mar 30 '18 at 12:18

Kanhaiya lal

880417

edited Mar 30 '18 at 12:18

Kanhaiya lal

880417

answered Dec 30 '16 at 8:46

MrTo-KaneMrTo-Kane

1,78162465

answered Dec 30 '16 at 8:46

MrTo-KaneMrTo-Kane

1,78162465