Creating a Table without Constraints - Access Module

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>>.
     
  2. Select Create table without constraints checkbox and click OK.
  3. Click Launch and run the export job.
     
  4. Connect to destination (for exampls, SQL Server database) and verify the srctable.
     

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