Try this from the R> while connected to your database: OUTPUT TableName.str -- UNLOAD STRUCTURE FOR TableName -- OUTPUT SCREEN
This will create a file with the table name and column definitions. There will also be commands for setting various environment variables. Note that there are also commands to disconnect the database and then create a database with the same name. What you will need to do is edit the TableName.str file and take out the commands related to creating a database and just leave the commands for creating the table. You can even rename the table in the command file if you need to. For a more complete explanation review the syntax for the UNLOAD command. Hope that helps. Mike Ramsour -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 20, 2001 5:27 PM To: [EMAIL PROTECTED] Subject: How to copy tables. 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
