Training
Module
Create tables in Microsoft Dataverse - Training
Explore secure data management with Dataverse, learning how to create tables and import data into a cloud-based storage system.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to: SQL Server SSIS Integration Runtime in Azure Data Factory
If you select Create destination table and then select Edit SQL in the Column Mappings dialog box, the SQL Server Import and Export Wizard shows the Create Table SQL Statement dialog box. On this page, you review and optionally customize the CREATE TABLE command that the wizard will run to create the new destination table.
Note
If you're looking for info about the Transact-SQL CREATE TABLE statement, and not about the Create Table SQL Statement dialog box of the SQL Server Import and Export Wizard, see CREATE TABLE (Transact-SQL).
The following screen shot shows the Create Table SQL Statement dialog box of the Wizard.
In this example, the SQL statement box contains the default CREATE TABLE statement generated by the wizard. This statement creates a new destination table named Person.AddressNew that's a copy of the Person.Address source table.
SQL statement
Displays the auto-generated SQL statement and lets you customize it.
If you change the default CREATE TABLE command, you may also have to make changes to the associated column mappings when you return to the Column Mappings dialog box.
To include a carriage return in the text of the SQL statement, press CTRL+ENTER. If you press ENTER alone, the dialog box closes.
For more info about the CREATE TABLE statement and syntax, see CREATE TABLE (Transact-SQL).
Autogenerate
Restore the default SQL statement, if you've changed it, by clicking Auto Generate.
The SQL Server Import and Export Wizard generates a default CREATE TABLE statement based on the connected data source. This default CREATE TABLE statement does not include the FILESTREAM attribute even if the source table has a FILESTREAM column.
For more info about the syntax, see CREATE TABLE (Transact-SQL). For more info about FILESTREAM, see Binary Large Object (Blob) Data (SQL Server).
After you review and customize the CREATE TABLE command and click OK, the Create Table SQL Statement dialog box returns you to the Column Mappings dialog box. For more info, see Column Mappings.
Get started with this simple example of the Import and Export Wizard
Training
Module
Create tables in Microsoft Dataverse - Training
Explore secure data management with Dataverse, learning how to create tables and import data into a cloud-based storage system.