Solved: convert teradata sql to sql server for creating a table

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