Stephen, The method used to 'clone' a table will probably vary from DB to DB.
One you have a duplicate table, I think I'm right in saying that the following syntax is quite common between different SQL engines: INSERT INTO NewTable SELECT * FROM ExistingTable Regards, Jon -----Original Message----- From: stephenyoung [mailto:[EMAIL PROTECTED]] Sent: 28 December 2002 18:43 To: Multiple recipients of list witango-talk Subject: Witango-Talk: Copying Tables Does anyone now how to copy a table as completely as possible using sql? Stephen Young [EMAIL PROTECTED] ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
