17.10 - Creating a Table without Constraints - Access Module

Teradata® Tools and Utilities Access Module Reference

Product
Access Module
Release Number
17.10
Published
October 2021
Language
English (United States)
Last Update
2021-11-02
dita:mapPath
uur1608578381725.ditamap
dita:ditavalPath
obe1474387269547.ditaval

Create table without constraints is a new feature in Teradata Access Module for OLE DB. It allows users to create the target table without any constraints.

Exporting a table from Teradata Database to SQL server with Create table without constraints feature:

  • Option 1: Select a Source

    Selected Teradata as source and used “srctable” with both not null and primary index constraints.

    CREATE SET TABLE EFXUSER.srctable ,FALLBACK ,
         NO BEFORE JOURNAL,
         NO AFTER JOURNAL,
         CHECKSUM = DEFAULT,
         DEFAULT MERGEBLOCKRATIO,
         MAP = TD_MAP1
         (
          A INTEGER NOT NULL,
          B CHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC,
    PRIMARY KEY ( A ));
    
  • Option 2: Select a Destination

    Select SQL Server as destination.

  • Option 3: Select from Settings
    1. Click Settings>>.
      Settings.svg
    2. Select Create table without constraints checkbox and click OK.
    3. Click Launch and run the export job.
      Launch.svg
    4. Connect to destination (for exampls, SQL Server database) and verify the srctable.
      Destination_Table.svg

A destination table (srctable) with two columns has been created without any keys.