SWAP
will swap all contents, metadata, and access permissions between two tables. This can be useful by allowing you to build a new version of the table over time and then when you are ready, swapping out the old verison for the new version.
Create Table Of Superheroes
-- Create a table called SUPERHEROES. If it already exists, replace it.
CREATE OR REPLACE TABLE SUPERHEROES (
-- Column called ID allowing up to five characters
"ID" VARCHAR(5),
-- Column called NAME allowing up to 100 characters
"NAME" VARCHAR(100),
-- Column called ALTER_EGO allowing up to 100 characters
"ALTER_EGO" VARCHAR(100)
);
Insert Rows For Each Superhero
-- Insert rows into SUPERHEROES
INSERT INTO SUPERHEROES
-- With the values
VALUES
('XF6K4', 'Chris Maki', 'The Bomber'),
('KD5SK', 'Donny Mav', 'Nuke Miner');
View Table Of Superheroes
-- View the SUPERHEROES table
SELECT * FROM SUPERHEROES;
ID |
NAME |
ALTER_EGO |
XF6K4 |
Chris Maki |
The Bomber |
KD5SK |
Donny Mav |
Nuke Miner |
Create Table Of Villans
-- Create a table called VILLANS. If it already exists, replace it.
CREATE OR REPLACE TABLE VILLANS (
-- Column called ID allowing up to five characters
"ID" VARCHAR(5),
-- Column called NAME allowing up to 100 characters
"NAME" VARCHAR(100),
-- Column called ALTER_EGO allowing up to 100 characters
"ALTER_EGO" VARCHAR(100)
);
Insert Rows For Each Villan
-- Insert rows into VILLANS
INSERT INTO VILLANS
-- With the values
VALUES
('KXD33', 'Millie Macoon', 'Slasher'),
('LKD92', 'Jason Jones', 'The Blade');
View Table Of Villans
-- View the VILLANS table
SELECT * FROM VILLANS;
ID |
NAME |
ALTER_EGO |
KXD33 |
Millie Macoon |
Slasher |
LKD92 |
Jason Jones |
The Blade |
Swap Superhero and Villan Tables
-- Swap the SUPERHEROES and VILLANS tables
ALTER TABLE IF EXISTS SUPERHEROES SWAP WITH VILLANS;
View New Table Of Superheroes
-- View the SUPERHEROES table
SELECT * FROM SUPERHEROES;
ID |
NAME |
ALTER_EGO |
KXD33 |
Millie Macoon |
Slasher |
LKD92 |
Jason Jones |
The Blade |
View New Table Of Villans
-- View the VILLANS table
SELECT * FROM VILLANS;
ID |
NAME |
ALTER_EGO |
XF6K4 |
Chris Maki |
The Bomber |
KD5SK |
Donny Mav |
Nuke Miner |