Tuesday, June 14, 2011

Duplicating a Table

You can make a copy of a tables structure, its stored procedures, trigger expressions, and default field values by using the language. There is no menu option to perform the same function. This procedure does not copy the contents of the table.

To duplicate a table
1. Open the original table.
2. Use the COPY STRUCTURE command to make a copy of the original table.

3. Open the empty table created with the COPY STRUCTURE command.
4. Use the APPEND FROM command to copy the data from the original table.

No comments:

Post a Comment