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.
There are a couple of ways this can be accomplished, depending on what tools you want to use.
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
Edutainer, ITProTV
**if the post above has answered the question, please mark the topic as solved.
@Mike-Rodrick said in COPY A EXISTING TABLE:
SELECT * INTO newtable
FROM oldtable
WHERE 1 = 0;
Great thanks! works a treat.