To copy tables from an existing schema

  1. Create a new schema. How?

  2. Right-click the new schema and select Add Tables. The Database Identification dialog box appears with the Advanced options displayed.

  3. Select the Copy Tables from Schema check box and select the schema from the list box that you want to copy tables from.

  4. Click the Next button. The Create Schema dialog box appears.

  5. Check that the tables, views, and/or procedures are correct and click the Finish button.