Removing a table with DROP TABLE

$ settings --editor

Show hidden files

Use vim keybindings

$ settings --general

Code execution endpoint:

$ save --settings

SQL for beginners

Removing a table with DROP TABLE #

The DROP TABLE statement permanently removes a table and every row it contains:

DROP TABLE table_name;

table_name: The table to remove.

There is no undo

Unlike DELETE, which removes rows but keeps the table itself, DROP TABLE removes the table's structure and all of its data at once. There is no WHERE clause to narrow it down — always be certain before running it.

Exercise #

Write a command that removes the order_items table entirely, without affecting any other table.

Tests #

The order_items table no longer exists.
The customers, products, and orders tables still exist.

Solution

DROP TABLE order_items;

Language

Output will be displayed here

aW1wb3J0IHNxbGl0ZTMKaW1wb3J0IG9zCmZyb20gZmFrZXIgaW1wb3J0IEZha2VyCmZyb20gcHJldHR5dGFibGUgaW1wb3J0IGZyb21fZGJfY3Vyc29yLCBNQVJLRE9XTgpmcm9tIGVudW0gaW1wb3J0IEVudW0KCgpkZWYgc2V0dXAoY29ubmVjdGlvbik6CiAgICBmYWtlID0gRmFrZXIoKQogICAgRmFrZXIuc2VlZCgwKQoKICAgIGN1ciA9IGNvbm5lY3Rpb24uY3Vyc29yKCkKCiAgICBjdXIuZXhlY3V0ZSgiQ1JFQVRFIFRBQkxFIGN1c3RvbWVycyhpZCwgZmlyc3RfbmFtZSwgbGFzdF9uYW1lLCBhZ2UsIGdlbmRlcikiKQoKICAgIGNsYXNzIEdlbmRlcihFbnVtKToKICAgICAgICBNID0gIk0iCiAgICAgICAgRiA9ICJGIgoKICAgIGZvciBpIGluIHJhbmdlKDEwKToKICAgICAgICBjdXIuZXhlY3V0ZSgKICAgICAgICAgICAgIklOU0VSVCBJTlRPIGN1c3RvbWVycyAoaWQsIGZpcnN0X25hbWUsIGxhc3RfbmFtZSwgYWdlLCBnZW5kZXIpIFZBTFVFUyAoPywgPywgPywgPywgPykiLAogICAgICAgICAgICAoCiAgICAgICAgICAgICAgICBpICsgMSwKICAgICAgICAgICAgICAgIGZha2UuZmlyc3RfbmFtZSgpLAogICAgICAgICAgICAgICAgZmFrZS5sYXN0X25hbWUoKSwKICAgICAgICAgICAgICAgIGZha2UucHlpbnQobWF4X3ZhbHVlPTgwKSArIDIwLAogICAgICAgICAgICAgICAgZmFrZS5lbnVtKEdlbmRlcikudmFsdWUpCiAgICAgICAgICAgICkKCiAgICBjdXIuZXhlY3V0ZSgiQ1JFQVRFIFRBQkxFIHByb2R1Y3RzKGlkLCBuYW1lLCBjYXRlZ29yeSwgcHJpY2UpIikKCiAgICBwcm9kdWN0cyA9IFsKICAgICAgICAoMSwgIldpcmVsZXNzIE1vdXNlIiwgIkVsZWN0cm9uaWNzIiwgMTkuOTkpLAogICAgICAgICgyLCAiQmx1ZXRvb3RoIFNwZWFrZXIiLCAiRWxlY3Ryb25pY3MiLCA0NS41MCksCiAgICAgICAgKDMsICJZb2dhIE1hdCIsICJGaXRuZXNzIiwgMjUuMDApLAogICAgICAgICg0LCAiUnVubmluZyBTaG9lcyIsICJGaXRuZXNzIiwgNjAuMDApLAogICAgICAgICg1LCAiQ29mZmVlIE11ZyIsICJIb21lIiwgOC41MCksCiAgICAgICAgKDYsICJEZXNrIExhbXAiLCAiSG9tZSIsIDIyLjAwKSwKICAgICAgICAoNywgIk5vdGVib29rIiwgIk9mZmljZSIsIDMuNTApLAogICAgICAgICg4LCAiQmFja3BhY2siLCAiT2ZmaWNlIiwgNDAuMDApLAogICAgXQoKICAgIGN1ci5leGVjdXRlbWFueSgiSU5TRVJUIElOVE8gcHJvZHVjdHMgKGlkLCBuYW1lLCBjYXRlZ29yeSwgcHJpY2UpIFZBTFVFUyAoPywgPywgPywgPykiLCBwcm9kdWN0cykKCiAgICBjdXIuZXhlY3V0ZSgiQ1JFQVRFIFRBQkxFIG9yZGVycyhpZCwgY3VzdG9tZXJfaWQsIG9yZGVyX2RhdGUsIHN0YXR1cywgc2hpcHBlZF9kYXRlKSIpCgogICAgY2xhc3MgU3RhdHVzKEVudW0pOgogICAgICAgIFBFTkRJTkcgPSAiUGVuZGluZyIKICAgICAgICBTSElQUEVEID0gIlNoaXBwZWQiCiAgICAgICAgREVMSVZFUkVEID0gIkRlbGl2ZXJlZCIKICAgICAgICBDQU5DRUxMRUQgPSAiQ2FuY2VsbGVkIgoKICAgIG9yZGVyX2NvdW50ID0gMjAKICAgIGZvciBpIGluIHJhbmdlKG9yZGVyX2NvdW50KToKICAgICAgICBzdGF0dXMgPSBmYWtlLmVudW0oU3RhdHVzKS52YWx1ZQogICAgICAgIG9yZGVyX2RhdGUgPSBmYWtlLmRhdGVfYmV0d2VlbihzdGFydF9kYXRlPSItMXkiLCBlbmRfZGF0ZT0idG9kYXkiKQogICAgICAgIHNoaXBwZWRfZGF0ZSA9IE5vbmUKICAgICAgICBpZiBzdGF0dXMgaW4gKCJTaGlwcGVkIiwgIkRlbGl2ZXJlZCIpOgogICAgICAgICAgICBzaGlwcGVkX2RhdGUgPSBmYWtlLmRhdGVfYmV0d2VlbihzdGFydF9kYXRlPW9yZGVyX2RhdGUsIGVuZF9kYXRlPSJ0b2RheSIpLmlzb2Zvcm1hdCgpCgogICAgICAgIGN1ci5leGVjdXRlKAogICAgICAgICAgICAiSU5TRVJUIElOVE8gb3JkZXJzIChpZCwgY3VzdG9tZXJfaWQsIG9yZGVyX2RhdGUsIHN0YXR1cywgc2hpcHBlZF9kYXRlKSBWQUxVRVMgKD8sID8sID8sID8sID8pIiwKICAgICAgICAgICAgKAogICAgICAgICAgICAgICAgaSArIDEsCiAgICAgICAgICAgICAgICBmYWtlLnB5aW50KG1pbl92YWx1ZT0xLCBtYXhfdmFsdWU9MTApLAogICAgICAgICAgICAgICAgb3JkZXJfZGF0ZS5pc29mb3JtYXQoKSwKICAgICAgICAgICAgICAgIHN0YXR1cywKICAgICAgICAgICAgICAgIHNoaXBwZWRfZGF0ZSkKICAgICAgICAgICAgKQoKICAgIGN1ci5leGVjdXRlKCJDUkVBVEUgVEFCTEUgb3JkZXJfaXRlbXMoaWQsIG9yZGVyX2lkLCBwcm9kdWN0X2lkLCBxdWFudGl0eSwgdW5pdF9wcmljZSkiKQoKICAgIGl0ZW1faWQgPSAxCiAgICBmb3Igb3JkZXJfaWQgaW4gcmFuZ2UoMSwgb3JkZXJfY291bnQgKyAxKToKICAgICAgICBpdGVtX2NvdW50ID0gZmFrZS5weWludChtaW5fdmFsdWU9MSwgbWF4X3ZhbHVlPTMpCiAgICAgICAgZm9yIF8gaW4gcmFuZ2UoaXRlbV9jb3VudCk6CiAgICAgICAgICAgIHByb2R1Y3RfaWQgPSBmYWtlLnB5aW50KG1pbl92YWx1ZT0xLCBtYXhfdmFsdWU9bGVuKHByb2R1Y3RzKSkKICAgICAgICAgICAgdW5pdF9wcmljZSA9IHByb2R1Y3RzW3Byb2R1Y3RfaWQgLSAxXVszXQogICAgICAgICAgICBjdXIuZXhlY3V0ZSgKICAgICAgICAgICAgICAgICJJTlNFUlQgSU5UTyBvcmRlcl9pdGVtcyAoaWQsIG9yZGVyX2lkLCBwcm9kdWN0X2lkLCBxdWFudGl0eSwgdW5pdF9wcmljZSkgVkFMVUVTICg/LCA/LCA/LCA/LCA/KSIsCiAgICAgICAgICAgICAgICAoCiAgICAgICAgICAgICAgICAgICAgaXRlbV9pZCwKICAgICAgICAgICAgICAgICAgICBvcmRlcl9pZCwKICAgICAgICAgICAgICAgICAgICBwcm9kdWN0X2lkLAogICAgICAgICAgICAgICAgICAgIGZha2UucHlpbnQobWluX3ZhbHVlPTEsIG1heF92YWx1ZT01KSwKICAgICAgICAgICAgICAgICAgICB1bml0X3ByaWNlKQogICAgICAgICAgICAgICAgKQogICAgICAgICAgICBpdGVtX2lkICs9IDEKCgppZiBfX25hbWVfXyA9PSAiX19tYWluX18iOgoKICAgIGNvbiA9IHNxbGl0ZTMuY29ubmVjdCgidHV0b3JpYWwuZGIiKQogICAgY3VyID0gY29uLmN1cnNvcigpCiAgICBzZXR1cChjb25uZWN0aW9uPWNvbikKICAgIHF1ZXJ5ID0gb3BlbigncXVlcnkuc3FsJywgJ3InKS5yZWFkKCkKICAgIHRyeToKICAgICAgICByZXMgPSBjdXIuZXhlY3V0ZShxdWVyeSkKICAgICAgICB0YWJsZSA9IGZyb21fZGJfY3Vyc29yKGN1cikKICAgICAgICBwcmludCh0YWJsZSkKICAgIGV4Y2VwdCBFeGNlcHRpb24gYXMgZToKICAgICAgICBwcmludCgiRXJyb3I6Iiwgc3RyKGUpKQo=