With MSSQL, use DTS You can also do:
SELECT * INTO newTable FROM oldTable in many RDBMSes You can also generate the CREATE table and INSERT statements (using a language of your choice) David L. Penton, Microsoft MVP JCPenney Application Specialist / Lead "Mathematics is music for the mind, and Music is Mathematics for the Soul. - J.S. Bach" [EMAIL PROTECTED] Do you have the VBScript Docs or SQL BOL installed? If not, why not? VBScript Docs: http://www.davidpenton.com/vbscript SQL BOL: http://www.davidpenton.com/sqlbol -----Original Message----- From: Andy Hayman [mailto:[EMAIL PROTECTED]] 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 --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
