COPY A EXISTING TABLE

---

Hi,

i'm currently at the section of data types etc and you've shown how to create a table etc.
Obviously some tables may have 50 fields and its quite a long job to write the script to create a table of 50 fields if i already having an existing table with same structure.

Is there an easy way using CREATE TABLE etc to copy an existing tables structure and create a new table with it please?

it may be you're coming to this further in episode but incase not.

@Stuart-Brown ,

There are a couple of ways this can be accomplished, depending on what tools you want to use.

https://docs.microsoft.com/en-us/sql/relational-databases/tables/duplicate-tables?view=sql-server-ver15

You can also use a SELECT INTO statement, and use a where clause to force the query to return no data. This will give you a new empty table, with the same schema.

SELECT * INTO newtable
FROM oldtable
WHERE 1 = 0;

@Mike-Rodrick said in COPY A EXISTING TABLE:

SELECT * INTO newtable
FROM oldtable
WHERE 1 = 0;

Great thanks! works a treat.