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 );