OUTPUT newtable.STR UNLOAD STRUCTURE FOR oldtable RBEDIT newtable.STR *( delete extraneous stuff. Do a global search and replace on the old table name with the new table name (in all CREATE TABLE and ALTER TABLE commands, and COMMENT ON commands.) RUN newtable.STR
Bill On Thu, 20 Dec 2001 17:26:52 EST, [EMAIL PROTECTED] wrote: >Does anyone know a quick and dirty way of copying tables in a database? (Just need to copy the structure.) >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l
