Swap Two Tables

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