-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 This will not copy constraints, or keys, but it will create the columns, and move the data.
SELECT * INTO tblNewTable FROM tblOldTable; Ben Timby Webexcellence PH: 317.423.3548 x23 TF: 800.808.6332 x23 FX: 317.423.8735 [EMAIL PROTECTED] www.webexc.com - - -----Original Message----- From: Andy Hayman [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 6:44 AM To: ActiveServerPages Subject: Cloning Tables with SQL Hey all Is it possible to "clone" or copy an existing table, basicly I want to copy a table with its structure and data on the fly, I know I can INSERT a table then copy the data by reading it then writing it but is there a copy or clone command? - - --- Andy Hayman Kensington Computers Internet & Computers Systems Consultant Web <http://www.ken.co.uk> Email <mailto:[EMAIL PROTECTED]> Telephone 020 7835 1282 Fax: 020 7373 6900 Disclaimer This e-mail is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not represent those of Kensington Computers. If you are not the intended recipient, be advised that you have received this mail in error and that any use, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited. - - --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% -----BEGIN PGP SIGNATURE----- Version: PGP 7.0.4 iQA/AwUBPYC40fnby1cCm2Q8EQLifwCg4v3b46qKLRsfxjGIePRXIoMzaK0AoKbm Id2QhfCrvnEPL5pPBFTSTQEX =4SZ3 -----END PGP SIGNATURE----- --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
