convert teradata sql to sql server for creating a table

Fordraiders
Fordraiders used Ask the Experts™
on
teradata and sql server

I have a create table sql from Teradata:
I need it revamped to create a table in sql server ?
CREATE MULTISET TABLE PRD_DWH_QT_XREF.s_xref_data ,NO FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL,
     CHECKSUM = DEFAULT,
     DEFAULT MERGEBLOCKRATIO
     (
      material_no_ref VARCHAR(14) CHARACTER SET LATIN NOT CASESPECIFIC,
      comp_code_ref VARCHAR(3) CHARACTER SET LATIN NOT CASESPECIFIC,
      comp_sku_condensed_ref VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,
      match_type_code_ref VARCHAR(2) CHARACTER SET LATIN NOT CASESPECIFIC,
      quantity_correction DECIMAL(14,6),
      "comment" VARCHAR(250) CHARACTER SET LATIN NOT CASESPECIFIC)
PRIMARY INDEX ( material_no_ref );

Open in new window



Thanks
fordraiders
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Administrator
Top Expert 2005
Commented:
I'm not familiar with all of the Teradata settings but this should cover most of it at least:

CREATE TABLE PRD_DWH_QT_XREF.s_xref_data
(
	material_no_ref			VARCHAR(14) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL PRIMARY KEY,
	comp_code_ref			VARCHAR(3) COLLATE SQL_Latin1_General_CP1_CI_AS,
	comp_sku_condensed_ref	VARCHAR(30) COLLATE SQL_Latin1_General_CP1_CI_AS,
	match_type_code_ref		VARCHAR(2) COLLATE SQL_Latin1_General_CP1_CI_AS,
	quantity_correction		DECIMAL(14,6),
	comment					VARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS
)

Open in new window

Author

Commented:
Thanks Brian !!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial