Gsyfuy

Why was Germany not as successful as other Europeans in establishing overseas colonies?

How come there are so many candidates for the 2020 Democratic party presidential nomination?

Any examples of headwear for races with animal ears?

Examples of subgroups where it's nontrivial to show closure under multiplication?

What route did the Hindenburg take when traveling from Germany to the U.S.?

Do I have to worry about players making “bad” choices on level up?

Sci fi novel series with instant travel between planets through gates. A river runs through the gates

What's the polite way to say "I need to urinate"?

Does Gita support doctrine of eternal samsara?

Does the sign matter for proportionality?

How did Captain America manage to do this?

What does the "ep" capability mean?

Unexpected email from Yorkshire Bank

Will tsunami waves travel forever if there was no land?

a sore throat vs a strep throat vs strep throat

How much cash can I safely carry into the USA and avoid civil forfeiture?

What is the relationship between spectral sequences and obstruction theory?

How do I reattach a shelf to the wall when it ripped out of the wall?

What do the phrase "Reeyan's seacrest" and the word "fraggle" mean in a sketch?

How to make a pipeline wait for end-of-file or stop after an error?

What is the difference between `command a[bc]d` and `command `a{b,c}d`

simple conditions equation

How can I practically buy stocks?

Why do Computer Science majors learn Calculus?

How to drop a table in Declarative schema?

Magento 2.3 : How to implement declarative schema in custom moduleMagento2 : How to database schema upgradeSet default values in Install SchemaMagento 2 How to Upgrades schemaCould someone please explain Declarative Database SchemaMagento 2.3 : How to implement declarative schema in custom moduleHow to add a Customer Attribute in a custom module using declarative schema in Magento 2.3?After Upgrade 2.2.5 to 2.3.0 Getting Error:CMS_BLOCK_STORE_BLOCK_ID_CMS_BLOCK_BLOCK_ID' to system tables,Why the table column is not deleted after changing the db_schema.xml?Errors on Declarative Schema on custom module on 2.3Magento 2.3 : Insert data into table using DeclarativeSchema

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}

2

How to drop a table in Magento 2.3.0 using declarative schema ?

database magento2.3 magento2.3.0

share|improve this question

edited Jan 9 at 9:15

Keyur Shah

13.6k24165

asked Jan 9 at 9:03

Dasharath PatelDasharath Patel

1369

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  what happens if you completely remove the table from the db_schema.xml file?
  
  – Marius♦
  Jan 9 at 9:04
  
  
  

  
  
  
  

add a comment | 

2

How to drop a table in Magento 2.3.0 using declarative schema ?

database magento2.3 magento2.3.0

share|improve this question

edited Jan 9 at 9:15

Keyur Shah

13.6k24165

asked Jan 9 at 9:03

Dasharath PatelDasharath Patel

1369

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  what happens if you completely remove the table from the db_schema.xml file?
  
  – Marius♦
  Jan 9 at 9:04
  
  
  

  
  
  
  

add a comment | 

How to drop a table in Magento 2.3.0 using declarative schema ?

database magento2.3 magento2.3.0

share|improve this question

edited Jan 9 at 9:15

Keyur Shah

13.6k24165

asked Jan 9 at 9:03

Dasharath PatelDasharath Patel

1369

share|improve this question

edited Jan 9 at 9:15

Keyur Shah

13.6k24165

asked Jan 9 at 9:03

Dasharath PatelDasharath Patel

1369

share|improve this question

edited Jan 9 at 9:15

Keyur Shah

13.6k24165

asked Jan 9 at 9:03

Dasharath PatelDasharath Patel

1369

edited Jan 9 at 9:15

Keyur Shah

13.6k24165

edited Jan 9 at 9:15

Keyur Shah

13.6k24165

asked Jan 9 at 9:03

Dasharath PatelDasharath Patel

1369

asked Jan 9 at 9:03

Dasharath PatelDasharath Patel

1369

2 Answers
2

active

oldest

votes

1

If you want to drop table, then you can either remove entire table node from xml file or you can set disabled attribute to true as like below line in your db_schema.xml :

<table name="rh_helloworld" resource="default" engine="innodb" comment="RH Helloworld" disabled="true">

 ..

 </table>

Resource

share|improve this answer

edited Jan 9 at 9:23

Amit Bera♦

60.3k1678178

answered Jan 9 at 9:19

Rohan HapaniRohan Hapani

7,16931865

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I have checked its not working. Gettign Error: Element 'table', attribute 'disabled': The attribute 'disabled' is not allowed. Line: 5 Verify the XML and try again.
  
  – Ashish Viradiya
  Jan 9 at 12:09
  

  
  
  
  

add a comment | 

0

Please follow below steps for drop table using db_schema.xml in Magento 2.3.X

1) Disable table

First of all, you need to add disabled="true" attribute in your table node.

<table name="abcd" resource="default" engine="innodb" comment="Table" disabled="true">

2) Set blank table node

Remove all nodes in between table

<table name="abcd" resource="default" engine="innodb" comment="Table" disabled="true">



</table>

3) Run commands

If you want to remove table so you must generate/update db_schema_whitelist.json in your module so please run below command before setup upgrade

1) php bin/magento setup:db-declaration:generate-whitelist --module-name=[Vendor_Module]



2) php bin/magento setup:upgrade

share|improve this answer

answered 11 mins ago

Deexit SanghaniDeexit Sanghani

890422

add a comment | 

Your Answer

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%2f257212%2fhow-to-drop-a-table-in-declarative-schema%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

1

If you want to drop table, then you can either remove entire table node from xml file or you can set disabled attribute to true as like below line in your db_schema.xml :

<table name="rh_helloworld" resource="default" engine="innodb" comment="RH Helloworld" disabled="true">

 ..

 </table>

Resource

share|improve this answer

edited Jan 9 at 9:23

Amit Bera♦

60.3k1678178

answered Jan 9 at 9:19

Rohan HapaniRohan Hapani

7,16931865

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I have checked its not working. Gettign Error: Element 'table', attribute 'disabled': The attribute 'disabled' is not allowed. Line: 5 Verify the XML and try again.
  
  – Ashish Viradiya
  Jan 9 at 12:09
  

  
  
  
  

add a comment | 

1

If you want to drop table, then you can either remove entire table node from xml file or you can set disabled attribute to true as like below line in your db_schema.xml :

<table name="rh_helloworld" resource="default" engine="innodb" comment="RH Helloworld" disabled="true">

 ..

 </table>

Resource

share|improve this answer

edited Jan 9 at 9:23

Amit Bera♦

60.3k1678178

answered Jan 9 at 9:19

Rohan HapaniRohan Hapani

7,16931865

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I have checked its not working. Gettign Error: Element 'table', attribute 'disabled': The attribute 'disabled' is not allowed. Line: 5 Verify the XML and try again.
  
  – Ashish Viradiya
  Jan 9 at 12:09
  

  
  
  
  

add a comment | 

If you want to drop table, then you can either remove entire table node from xml file or you can set disabled attribute to true as like below line in your db_schema.xml :

<table name="rh_helloworld" resource="default" engine="innodb" comment="RH Helloworld" disabled="true">

 ..

 </table>

Resource

share|improve this answer

edited Jan 9 at 9:23

Amit Bera♦

60.3k1678178

answered Jan 9 at 9:19

Rohan HapaniRohan Hapani

7,16931865

<table name="rh_helloworld" resource="default" engine="innodb" comment="RH Helloworld" disabled="true">

 ..

 </table>

share|improve this answer

edited Jan 9 at 9:23

Amit Bera♦

60.3k1678178

answered Jan 9 at 9:19

Rohan HapaniRohan Hapani

7,16931865

edited Jan 9 at 9:23

Amit Bera♦

60.3k1678178

edited Jan 9 at 9:23

Amit Bera♦

60.3k1678178

answered Jan 9 at 9:19

Rohan HapaniRohan Hapani

7,16931865

answered Jan 9 at 9:19

Rohan HapaniRohan Hapani

7,16931865

0

Please follow below steps for drop table using db_schema.xml in Magento 2.3.X

1) Disable table

First of all, you need to add disabled="true" attribute in your table node.

<table name="abcd" resource="default" engine="innodb" comment="Table" disabled="true">

2) Set blank table node

Remove all nodes in between table

<table name="abcd" resource="default" engine="innodb" comment="Table" disabled="true">



</table>

3) Run commands

If you want to remove table so you must generate/update db_schema_whitelist.json in your module so please run below command before setup upgrade

1) php bin/magento setup:db-declaration:generate-whitelist --module-name=[Vendor_Module]



2) php bin/magento setup:upgrade

share|improve this answer

answered 11 mins ago

Deexit SanghaniDeexit Sanghani

890422

add a comment | 

0

Please follow below steps for drop table using db_schema.xml in Magento 2.3.X

1) Disable table

First of all, you need to add disabled="true" attribute in your table node.

<table name="abcd" resource="default" engine="innodb" comment="Table" disabled="true">

2) Set blank table node

Remove all nodes in between table

<table name="abcd" resource="default" engine="innodb" comment="Table" disabled="true">



</table>

3) Run commands

If you want to remove table so you must generate/update db_schema_whitelist.json in your module so please run below command before setup upgrade

1) php bin/magento setup:db-declaration:generate-whitelist --module-name=[Vendor_Module]



2) php bin/magento setup:upgrade

share|improve this answer

answered 11 mins ago

Deexit SanghaniDeexit Sanghani

890422

add a comment | 

Please follow below steps for drop table using db_schema.xml in Magento 2.3.X

1) Disable table

First of all, you need to add disabled="true" attribute in your table node.

<table name="abcd" resource="default" engine="innodb" comment="Table" disabled="true">

2) Set blank table node

Remove all nodes in between table

<table name="abcd" resource="default" engine="innodb" comment="Table" disabled="true">



</table>

3) Run commands

If you want to remove table so you must generate/update db_schema_whitelist.json in your module so please run below command before setup upgrade

1) php bin/magento setup:db-declaration:generate-whitelist --module-name=[Vendor_Module]



2) php bin/magento setup:upgrade

share|improve this answer

answered 11 mins ago

Deexit SanghaniDeexit Sanghani

890422

<table name="abcd" resource="default" engine="innodb" comment="Table" disabled="true">

<table name="abcd" resource="default" engine="innodb" comment="Table" disabled="true">



</table>

1) php bin/magento setup:db-declaration:generate-whitelist --module-name=[Vendor_Module]



2) php bin/magento setup:upgrade

share|improve this answer

answered 11 mins ago

Deexit SanghaniDeexit Sanghani

890422

answered 11 mins ago

Deexit SanghaniDeexit Sanghani

890422

answered 11 mins ago

Deexit SanghaniDeexit Sanghani

890422