[SQL Server] Create Tables
Q100121: [SQL Server] Create Tables
Creates tables in a SQL Server database based on the provided source data files.
| Parameter | In/Out | Description | Other Info |
|---|---|---|---|
| DB connection | In | Assign a defined SQL Server Connection or directly enter the parameters and values which make up a valid connection for SQL Server. |
Connection type: sysSQLServer |
| File source | InOut | One or more pathnames (files) containing data files that will be scanned to determine the field structure to generate (it's common to use the FileList output variable from the [Files] Find module). If using in conjunction with the [SQL Server] Import module, typically this should be the same list of files you will use with that module. |
|
| Schema Name | In | The Schema Name to be used for all new table(s) created. Any specified schema name must already exist. |
|
| Create schema name if needed | In | The Schema Name is expected to already exist by default. If it should be created if it does not exist, then set this parameter option to True. |
Default: false |
| Table name | In | If using in conjunction with the [SQL Server] Import module, this parameter is used the same way as the parameter of the same name in the import module.If specified, the tables names for the corresponding file source will use the name specified. If not specified, the table name will be based on the base file name(s) of the source file(s) (or tab names for Excel files). |
|
| Append source filename? | In | When TRUE, the table names will use the base Filename portion of the import file (or the tab name if it's a spreadsheet) and append it to the specified TableName with an underscore ("_") between them. Ex: "schemaname.TableName_MyImportFileName" or "schemaname.TableName_MyExcelTabName" | |
| Data has a header row? | In | Does the first row of data contain column names? If there is no header row, then the columns must exactly correspond to the columns in the database, both in number and in order. |
|
| Drop and recreate table? | In | Should the target tables be dropped and recreated if they already exist? | Default: false |
| Data scan limit | In | Choices: ScanAll, ScanPartialHow much of the data from the source files should the module scan for determining column definitions? |
Default: ScanAll |
| Log output level | In | Choices: Minimal, VerboseThe level of execution detail you want to appear in the log. |
Default: Minimal |
| Processed file list | Out | List of the source files that were processed. Each of these will align 1:1 with the parallel table names in the TableList output parameter. | |
| Processed table list | Out | List of tables that were processed. Each of these will match the parallel files in the FileList output parameter. | |
| Execution output | Out | Text returned by PRINT statements in SQL being executed. |
(Italics = required parameters)
Notes
The [SQL Server] Create Tables module is useful for setting up database tables that match the structure of your data files, allowing for easier data import and management.
When using this module, you will need to specify the connection details for your SQL Server instance, as well as the source data files that contain the schema information. The module will read the structure of the data files and run the appropriate SQL commands to create the tables in the specified database.
Last Updated:
1/28/2026 4:28:15 PM