This documentation is archived and is not being maintained.

Create Table SQL Statement (SQL Server Import and Export Wizard)

Use the Create Table SQL Statement dialog box to view the statement that was generated automatically, or to modify it for your purposes. If you modify this statement, you may also have to make associated changes to column mapping, and you will have to maintain the edited SQL statement manually thereafter.

To learn more about this wizard, see Creating Packages Using the SQL Server Import and Export Wizard. To learn about the options for starting the wizard, as well as the permissions required to run the wizard successfully, see How to: Start the SQL Server Import and Export Wizard.

The purpose of the SQL Server Import and Export Wizard is to copy data from a source to a destination. The wizard can also create a destination database and destination tables for you. However, if you have to copy multiple databases or tables, or other kinds of database objects, you should use the Copy Database Wizard instead. For more information, see Using the Copy Database Wizard.

SQL statement

Displays the auto-generated SQL statement and lets it be edited.

If you want to include a carriage return in the SQL statement, press CTRL+ENTER. If you press only ENTER, the dialog box closes.


Restore the default SQL statement, if you have modified it, by clicking Autogenerate.