Can You Copy a Table in SQL?

[ukpi1b]

If you want create new table TBLNEW based on existing TBLOLD, run SELECT statement to outfile(F13 0pt1 then Opt3)with all fields you need. If you need different names in TBLNEW use LABLE ON(OFF) on new table or use alias names in your SELECT statement: SELECT OLDF1 NEWF1, OLDF2 NEWF2 ..... FROM TBLOLD.

[Guest.Visitor]

I've researched some SQL texts and searched the forum for an answer to this question but no luck. Can you copy a table in SQL similar to the procedure in DDS? I thought there was an SQL enhancement that would allow you to do this but can't find the reference. I would like to copy an existing table and rename it as it contains the fields needed in the second table. TIA, Bob

[Guest.Visitor]

Thanks, UKP. I also got a reply in another forum to do this: CREATE TABLE NEWTABLE LIKE OLDTABLE However, it only works in V5. Bob