TIL: Duplicate SQL Table Schema

Following some advice I got over on Hacker News I am going to start posting little Today I Learned posts as a way to help me ease into more consistent blog writing.

The Code

-- Note, I run this on Oracle DB
    WHERE 1 = 0

What this achieves and why

This will create a new table called NEW_TABLE that has the exact same schema as OLD_TABLE. (Note, I don't know if EVERYTHING is the same all the way down, but the schema is the same which is what I care about.)

I generally use this when I have external data coming from a spreadsheet, or an SQL script and I want to insert it into my OLD_TABLE, but first I need to perform some alterations to the data.

Before now I tended to copy the DDL from the source table and run it. This is much quicker!


#til #sql #oraclesql

If you have something to say don't forget to tag me (@wyrm@wyrm.one) so I can respond!

Or email me at blog (at) lennys (dot) quest.