Problem:

User created all tables in one location but would like to see the same tables under this authid in a different location as well.  Is there a way to sreate a sql file with all the tables and indexes in SQLWizard that can run against a different XDB location to create the same tables?

Resolution:

Yes.  Connect to SQLWizard using the Location and Authid that you want to export.

Click File - New - Export.

Select SQL Statements as the Format and check Create and Index.

Enter a file name under Target File Information.

Enter an asterisk under Table Name for Source Table Information.

Click Run.

The SQL statements are created in the file you created under Target File information and you can run this in another location to create the same tables.