Kevin - You've had lots of answers on this topic - here's the summary:
1. If you want to copy all the fields and all the data from one table to another, you can use the object manager (as you discovered). However, that does NOT copy Primary/Foreign Key designations, Indexes, Rules, Rights or Comments to the new table. You have to do that manually. Using the Object Manager is the same as the command: PROJECT table2 FROM table1 USING * 2. If you want to copy all or some of the fields but no data, or just selected data, you can use the PROJECT command as: PROJECT table2 FROM table1 USING columnlist WHERE whereclause. As in the example above, you will still have to recreate PK/FKs, indexes, rules, rights and comments to the new table. If you don't want any data, make the WHERE clause in this statement be "AND LIMIT = 0" 3. If you want to copy JUST the structure, including ALL the other table definitions, follow the examples given by other list members to "UNLOAD STRUCTURE FOR tablename". Then you edit the file, make your changes and run the file to create the new table with all field definitions. Happy Holidays! Sami ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, December 20, 2001 5:22 PM Subject: Re: How to copy tables. > Never mind. Object Manager. > ================================================ > 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
