
ALTER TABLE VS4TACAllocate ALTER COLUMN TACLTACCCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TACAllocate ALTER COLUMN TACLLn INT NOT NULL 
GO

ALTER TABLE VS4TACAllocate WITH NOCHECK ADD 
CONSTRAINT TACLTACCCode PRIMARY KEY CLUSTERED 
(
TACLTACCCode,TACLLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TACChart ALTER COLUMN TACCCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TACChart WITH NOCHECK ADD 
CONSTRAINT TACCCode PRIMARY KEY CLUSTERED 
(
TACCCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TAccountMap ALTER COLUMN TACMAlias NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAccountMap WITH NOCHECK ADD 
CONSTRAINT TACMAlias PRIMARY KEY CLUSTERED 
(
TACMAlias
) ON [PRIMARY]
GO

ALTER TABLE VS4TAccountPeriod ALTER COLUMN TACPTACYID INT NOT NULL 
GO

ALTER TABLE VS4TAccountPeriod ALTER COLUMN TACPID INT NOT NULL 
GO

ALTER TABLE VS4TAccountPeriod WITH NOCHECK ADD 
CONSTRAINT TACPTACYID PRIMARY KEY CLUSTERED 
(
TACPTACYID,TACPID
) ON [PRIMARY]
GO

ALTER TABLE VS4TAccountSet ALTER COLUMN TACSCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAccountSet WITH NOCHECK ADD 
CONSTRAINT TACSCode PRIMARY KEY CLUSTERED 
(
TACSCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TAccountSetMB ALTER COLUMN TACMTACSCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAccountSetMB ALTER COLUMN TACMBookCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAccountSetMB ALTER COLUMN TACMPayType INT NOT NULL 
GO

ALTER TABLE VS4TAccountSetMB ALTER COLUMN TACMFreeCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAccountSetMB WITH NOCHECK ADD 
CONSTRAINT TACMTACSCode PRIMARY KEY CLUSTERED 
(
TACMTACSCode,TACMBookCode,TACMPayType,TACMFreeCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TAccountYear ALTER COLUMN TACYID INT NOT NULL 
GO

ALTER TABLE VS4TAccountYear WITH NOCHECK ADD 
CONSTRAINT TACYID PRIMARY KEY CLUSTERED 
(
TACYID
) ON [PRIMARY]
GO

ALTER TABLE VS4TACFormat ALTER COLUMN TACFCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TACFormat WITH NOCHECK ADD 
CONSTRAINT TACFCode PRIMARY KEY CLUSTERED 
(
TACFCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TACFormatMB ALTER COLUMN TAFMTACFCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TACFormatMB ALTER COLUMN TAFMLn INT NOT NULL 
GO

ALTER TABLE VS4TACFormatMB WITH NOCHECK ADD 
CONSTRAINT TAFMTACFCode PRIMARY KEY CLUSTERED 
(
TAFMTACFCode,TAFMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TACGroup ALTER COLUMN TACGCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TACGroup WITH NOCHECK ADD 
CONSTRAINT TACGCode PRIMARY KEY CLUSTERED 
(
TACGCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TACGroupSub ALTER COLUMN TAGsCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TACGroupSub WITH NOCHECK ADD 
CONSTRAINT TAGsCode PRIMARY KEY CLUSTERED 
(
TAGsCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TAirline ALTER COLUMN TAILCode NVARCHAR (5) NOT NULL 
GO

ALTER TABLE VS4TAirline WITH NOCHECK ADD 
CONSTRAINT TAILCode PRIMARY KEY CLUSTERED 
(
TAILCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TAirSchedule ALTER COLUMN TAISTAILCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAirSchedule ALTER COLUMN TAISLn INT NOT NULL 
GO

ALTER TABLE VS4TAirSchedule WITH NOCHECK ADD 
CONSTRAINT TAISTAILCode PRIMARY KEY CLUSTERED 
(
TAISTAILCode,TAISLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TAllocate ALTER COLUMN TAolCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAllocate WITH NOCHECK ADD 
CONSTRAINT TAolCode PRIMARY KEY CLUSTERED 
(
TAolCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TAP ALTER COLUMN TAPNCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAP WITH NOCHECK ADD 
CONSTRAINT TAPNCode PRIMARY KEY CLUSTERED 
(
TAPNCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TAP2 ALTER COLUMN TAP2TAPNCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAP2 ALTER COLUMN TAP2Ln INT NOT NULL 
GO

ALTER TABLE VS4TAP2 WITH NOCHECK ADD 
CONSTRAINT TAP2TAPNCode PRIMARY KEY CLUSTERED 
(
TAP2TAPNCode,TAP2Ln
) ON [PRIMARY]
GO

ALTER TABLE VS4TAPBalance ALTER COLUMN TAPLTACPTACYID INT NOT NULL 
GO

ALTER TABLE VS4TAPBalance ALTER COLUMN TAPLTACPID INT NOT NULL 
GO

ALTER TABLE VS4TAPBalance ALTER COLUMN TAPLTAPNCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAPBalance ALTER COLUMN TAPLMode INT NOT NULL 
GO

ALTER TABLE VS4TAPBalance WITH NOCHECK ADD 
CONSTRAINT TAPLTACPTACYID PRIMARY KEY CLUSTERED 
(
TAPLTACPTACYID,TAPLTACPID,TAPLTAPNCode,TAPLMode
) ON [PRIMARY]
GO

ALTER TABLE VS4TAPBank ALTER COLUMN TAPBTAPNCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAPBank ALTER COLUMN TAPBLn INT NOT NULL 
GO

ALTER TABLE VS4TAPBank WITH NOCHECK ADD 
CONSTRAINT TAPBTAPNCode PRIMARY KEY CLUSTERED 
(
TAPBTAPNCode,TAPBLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TAPBill ALTER COLUMN TPBINo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAPBill WITH NOCHECK ADD 
CONSTRAINT TPBINo PRIMARY KEY CLUSTERED 
(
TPBINo
) ON [PRIMARY]
GO

ALTER TABLE VS4TAPBillMB ALTER COLUMN TPBMLn INT NOT NULL 
GO

ALTER TABLE VS4TAPBillMB ALTER COLUMN TPBMTPBINo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAPBillMB WITH NOCHECK ADD 
CONSTRAINT TPBMLn PRIMARY KEY CLUSTERED 
(
TPBMLn,TPBMTPBINo
) ON [PRIMARY]
GO

ALTER TABLE VS4TAPBranch ALTER COLUMN TAPUTAPNCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAPBranch ALTER COLUMN TAPUCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAPBranch WITH NOCHECK ADD 
CONSTRAINT TAPUTAPNCode PRIMARY KEY CLUSTERED 
(
TAPUTAPNCode,TAPUCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TAPBusinessType ALTER COLUMN TAPYTBsTCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAPBusinessType ALTER COLUMN TAPYTAPNCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAPBusinessType WITH NOCHECK ADD 
CONSTRAINT TAPYTBsTCode PRIMARY KEY CLUSTERED 
(
TAPYTBsTCode,TAPYTAPNCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TAPCampaign ALTER COLUMN TPCACode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAPCampaign WITH NOCHECK ADD 
CONSTRAINT TPCACode PRIMARY KEY CLUSTERED 
(
TPCACode
) ON [PRIMARY]
GO

ALTER TABLE VS4TAPCampaignMB ALTER COLUMN TPCPTPCACode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAPCampaignMB ALTER COLUMN TPCPLn SMALLINT NOT NULL 
GO

ALTER TABLE VS4TAPCampaignMB WITH NOCHECK ADD 
CONSTRAINT TPCPTPCACode PRIMARY KEY CLUSTERED 
(
TPCPTPCACode,TPCPLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TAPCard ALTER COLUMN TPICTAPNCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAPCard ALTER COLUMN TPICDocNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAPCard ALTER COLUMN TPICType NVARCHAR (2) NOT NULL 
GO

ALTER TABLE VS4TAPCard WITH NOCHECK ADD 
CONSTRAINT TPICTAPNCode PRIMARY KEY CLUSTERED 
(
TPICTAPNCode,TPICDocNo,TPICType
) ON [PRIMARY]
GO

ALTER TABLE VS4TAPContact ALTER COLUMN TAPCCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAPContact ALTER COLUMN TAPCTAPNCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAPContact WITH NOCHECK ADD 
CONSTRAINT TAPCCode PRIMARY KEY CLUSTERED 
(
TAPCCode,TAPCTAPNCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TAPCreditLimit ALTER COLUMN TPCLTAPNCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAPCreditLimit ALTER COLUMN TPCLStartDate DATETIME NOT NULL 
GO

ALTER TABLE VS4TAPCreditLimit WITH NOCHECK ADD 
CONSTRAINT TPCLTAPNCode PRIMARY KEY CLUSTERED 
(
TPCLTAPNCode,TPCLStartDate
) ON [PRIMARY]
GO

ALTER TABLE VS4TAPCreditNote ALTER COLUMN TPCNNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAPCreditNote WITH NOCHECK ADD 
CONSTRAINT TPCNNo PRIMARY KEY CLUSTERED 
(
TPCNNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TAPCreditNoteMB ALTER COLUMN TPCMLn INT NOT NULL 
GO

ALTER TABLE VS4TAPCreditNoteMB ALTER COLUMN TPCMTPCNNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAPCreditNoteMB WITH NOCHECK ADD 
CONSTRAINT TPCMLn PRIMARY KEY CLUSTERED 
(
TPCMLn,TPCMTPCNNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TAPDebitNote ALTER COLUMN TDENNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAPDebitNote WITH NOCHECK ADD 
CONSTRAINT TDENNo PRIMARY KEY CLUSTERED 
(
TDENNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TAPDebitNoteMB ALTER COLUMN TDEBLn INT NOT NULL 
GO

ALTER TABLE VS4TAPDebitNoteMB ALTER COLUMN TDEBTDENNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAPDebitNoteMB WITH NOCHECK ADD 
CONSTRAINT TDEBLn PRIMARY KEY CLUSTERED 
(
TDEBLn,TDEBTDENNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TAPDebtAdjust ALTER COLUMN TPAJNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAPDebtAdjust WITH NOCHECK ADD 
CONSTRAINT TPAJNo PRIMARY KEY CLUSTERED 
(
TPAJNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TAPDebtAdjustMB ALTER COLUMN TPJMLn INT NOT NULL 
GO

ALTER TABLE VS4TAPDebtAdjustMB ALTER COLUMN TPJMTPJANo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAPDebtAdjustMB WITH NOCHECK ADD 
CONSTRAINT TPJMLn PRIMARY KEY CLUSTERED 
(
TPJMLn,TPJMTPJANo
) ON [PRIMARY]
GO

ALTER TABLE VS4TAPGroup ALTER COLUMN TAPGCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAPGroup WITH NOCHECK ADD 
CONSTRAINT TAPGCode PRIMARY KEY CLUSTERED 
(
TAPGCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TAPImportantDay ALTER COLUMN TAPITAPNCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAPImportantDay ALTER COLUMN TAPILn INT NOT NULL 
GO

ALTER TABLE VS4TAPImportantDay WITH NOCHECK ADD 
CONSTRAINT TAPITAPNCode PRIMARY KEY CLUSTERED 
(
TAPITAPNCode,TAPILn
) ON [PRIMARY]
GO

ALTER TABLE VS4TAPInvoice ALTER COLUMN TIAPNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAPInvoice WITH NOCHECK ADD 
CONSTRAINT TIAPNo PRIMARY KEY CLUSTERED 
(
TIAPNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TAPInvoiceADJ ALTER COLUMN TIPJNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAPInvoiceADJ WITH NOCHECK ADD 
CONSTRAINT TIPJNo PRIMARY KEY CLUSTERED 
(
TIPJNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TAPInvoiceCost ALTER COLUMN TIPCTIAPNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAPInvoiceCost ALTER COLUMN TIPCToTIAPNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAPInvoiceCost WITH NOCHECK ADD 
CONSTRAINT TIPCTIAPNo PRIMARY KEY CLUSTERED 
(
TIPCTIAPNo,TIPCToTIAPNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TAPInvoiceMB ALTER COLUMN TIPMLn INT NOT NULL 
GO

ALTER TABLE VS4TAPInvoiceMB ALTER COLUMN TIPMTIAPNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAPInvoiceMB WITH NOCHECK ADD 
CONSTRAINT TIPMLn PRIMARY KEY CLUSTERED 
(
TIPMLn,TIPMTIAPNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TAPInvoiceMBAOL ALTER COLUMN TIPATIPMTIAPNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAPInvoiceMBAOL ALTER COLUMN TIPATIPMLn INT NOT NULL 
GO

ALTER TABLE VS4TAPInvoiceMBAOL WITH NOCHECK ADD 
CONSTRAINT TIPATIPMTIAPNo PRIMARY KEY CLUSTERED 
(
TIPATIPMTIAPNo,TIPATIPMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TAPInvoicePay ALTER COLUMN TPIPTIAPNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAPInvoicePay ALTER COLUMN TPIPLn INT NOT NULL 
GO

ALTER TABLE VS4TAPInvoicePay WITH NOCHECK ADD 
CONSTRAINT TPIPTIAPNo PRIMARY KEY CLUSTERED 
(
TPIPTIAPNo,TPIPLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TAPParent ALTER COLUMN TAPPTAPNCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAPParent ALTER COLUMN TAPPTAPNCode2 NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAPParent WITH NOCHECK ADD 
CONSTRAINT TAPPTAPNCode PRIMARY KEY CLUSTERED 
(
TAPPTAPNCode,TAPPTAPNCode2
) ON [PRIMARY]
GO

ALTER TABLE VS4TAppointType ALTER COLUMN TAtyCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAppointType WITH NOCHECK ADD 
CONSTRAINT TAtyCode PRIMARY KEY CLUSTERED 
(
TAtyCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TApproveOne ALTER COLUMN TAP1ID INT NOT NULL 
GO

ALTER TABLE VS4TApproveOne WITH NOCHECK ADD 
CONSTRAINT TAP1ID PRIMARY KEY CLUSTERED 
(
TAP1ID
) ON [PRIMARY]
GO

ALTER TABLE VS4TAPScroll ALTER COLUMN TASCTASGAlias NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAPScroll ALTER COLUMN TASCScroll INT NOT NULL 
GO

ALTER TABLE VS4TAPScroll WITH NOCHECK ADD 
CONSTRAINT TASCTASGAlias PRIMARY KEY CLUSTERED 
(
TASCTASGAlias,TASCScroll
) ON [PRIMARY]
GO

ALTER TABLE VS4TAPScrollGroup ALTER COLUMN TASGAlias NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAPScrollGroup WITH NOCHECK ADD 
CONSTRAINT TASGAlias PRIMARY KEY CLUSTERED 
(
TASGAlias
) ON [PRIMARY]
GO

ALTER TABLE VS4TAPType ALTER COLUMN TAPTCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAPType WITH NOCHECK ADD 
CONSTRAINT TAPTCode PRIMARY KEY CLUSTERED 
(
TAPTCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TAPVDocRef ALTER COLUMN TPVRTAPVNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAPVDocRef ALTER COLUMN TPVRLn INT NOT NULL 
GO

ALTER TABLE VS4TAPVDocRef WITH NOCHECK ADD 
CONSTRAINT TPVRTAPVNo PRIMARY KEY CLUSTERED 
(
TPVRTAPVNo,TPVRLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TAPVDocRefAOL ALTER COLUMN TPDATPVRTAPVNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAPVDocRefAOL ALTER COLUMN TPDATPVRLn INT NOT NULL 
GO

ALTER TABLE VS4TAPVDocRefAOL WITH NOCHECK ADD 
CONSTRAINT TPDATPVRTAPVNo PRIMARY KEY CLUSTERED 
(
TPDATPVRTAPVNo,TPDATPVRLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TAPVDocRefMB ALTER COLUMN TPVMTAPVNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAPVDocRefMB ALTER COLUMN TPVMLn INT NOT NULL 
GO

ALTER TABLE VS4TAPVDocRefMB WITH NOCHECK ADD 
CONSTRAINT TPVMTAPVNo PRIMARY KEY CLUSTERED 
(
TPVMTAPVNo,TPVMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TAPVoucher ALTER COLUMN TAPVNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAPVoucher WITH NOCHECK ADD 
CONSTRAINT TAPVNo PRIMARY KEY CLUSTERED 
(
TAPVNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TAPVoucherPay ALTER COLUMN TPVPTAPVNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAPVoucherPay ALTER COLUMN TPVPLn INT NOT NULL 
GO

ALTER TABLE VS4TAPVoucherPay WITH NOCHECK ADD 
CONSTRAINT TPVPTAPVNo PRIMARY KEY CLUSTERED 
(
TPVPTAPVNo,TPVPLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TAR ALTER COLUMN TARNCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAR WITH NOCHECK ADD 
CONSTRAINT TARNCode PRIMARY KEY CLUSTERED 
(
TARNCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TAR2 ALTER COLUMN TAR2TARNCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAR2 ALTER COLUMN TAR2Ln INT NOT NULL 
GO

ALTER TABLE VS4TAR2 WITH NOCHECK ADD 
CONSTRAINT TAR2TARNCode PRIMARY KEY CLUSTERED 
(
TAR2TARNCode,TAR2Ln
) ON [PRIMARY]
GO

ALTER TABLE VS4TAR2Product ALTER COLUMN TPHITARNCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAR2Product ALTER COLUMN TPHILn INT NOT NULL 
GO

ALTER TABLE VS4TAR2Product WITH NOCHECK ADD 
CONSTRAINT TPHITARNCode PRIMARY KEY CLUSTERED 
(
TPHITARNCode,TPHILn
) ON [PRIMARY]
GO

ALTER TABLE VS4TAR3 ALTER COLUMN TAR3TARNCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAR3 ALTER COLUMN TAR3Ln INT NOT NULL 
GO

ALTER TABLE VS4TAR3 WITH NOCHECK ADD 
CONSTRAINT TAR3TARNCode PRIMARY KEY CLUSTERED 
(
TAR3TARNCode,TAR3Ln
) ON [PRIMARY]
GO

ALTER TABLE VS4TARAppointComp ALTER COLUMN TARMTARANo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARAppointComp ALTER COLUMN TARMTTCPSTCPTCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARAppointComp ALTER COLUMN TARMTCPSCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARAppointComp WITH NOCHECK ADD 
CONSTRAINT TARMTARANo PRIMARY KEY CLUSTERED 
(
TARMTARANo,TARMTTCPSTCPTCode,TARMTCPSCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TARAppointMedia ALTER COLUMN TARETMedCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARAppointMedia ALTER COLUMN TARETARANo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARAppointMedia WITH NOCHECK ADD 
CONSTRAINT TARETMedCode PRIMARY KEY CLUSTERED 
(
TARETMedCode,TARETARANo
) ON [PRIMARY]
GO

ALTER TABLE VS4TARAppointment ALTER COLUMN TARANo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARAppointment WITH NOCHECK ADD 
CONSTRAINT TARANo PRIMARY KEY CLUSTERED 
(
TARANo
) ON [PRIMARY]
GO

ALTER TABLE VS4TARAppointPdt ALTER COLUMN TARRTARANo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARAppointPdt ALTER COLUMN TARRLn INT NOT NULL 
GO

ALTER TABLE VS4TARAppointPdt WITH NOCHECK ADD 
CONSTRAINT TARRTARANo PRIMARY KEY CLUSTERED 
(
TARRTARANo,TARRLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TARBalance ALTER COLUMN TARLTACPTACYID INT NOT NULL 
GO

ALTER TABLE VS4TARBalance ALTER COLUMN TARLTACPID INT NOT NULL 
GO

ALTER TABLE VS4TARBalance ALTER COLUMN TARLTARNCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARBalance ALTER COLUMN TARLMode INT NOT NULL 
GO

ALTER TABLE VS4TARBalance WITH NOCHECK ADD 
CONSTRAINT TARLTACPTACYID PRIMARY KEY CLUSTERED 
(
TARLTACPTACYID,TARLTACPID,TARLTARNCode,TARLMode
) ON [PRIMARY]
GO

ALTER TABLE VS4TARBill ALTER COLUMN TBilNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARBill WITH NOCHECK ADD 
CONSTRAINT TBilNo PRIMARY KEY CLUSTERED 
(
TBilNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TARBillMB ALTER COLUMN TBMBLn INT NOT NULL 
GO

ALTER TABLE VS4TARBillMB ALTER COLUMN TBMBTBilNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARBillMB WITH NOCHECK ADD 
CONSTRAINT TBMBLn PRIMARY KEY CLUSTERED 
(
TBMBLn,TBMBTBilNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TARBranch ALTER COLUMN TARDTARNCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARBranch ALTER COLUMN TARDCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARBranch WITH NOCHECK ADD 
CONSTRAINT TARDTARNCode PRIMARY KEY CLUSTERED 
(
TARDTARNCode,TARDCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TARBuddy ALTER COLUMN TABuTARNCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARBuddy ALTER COLUMN TABuLn INT NOT NULL 
GO

ALTER TABLE VS4TARBuddy WITH NOCHECK ADD 
CONSTRAINT TABuTARNCode PRIMARY KEY CLUSTERED 
(
TABuTARNCode,TABuLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TARBusinessType ALTER COLUMN TARBTBsTCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARBusinessType ALTER COLUMN TARBTARNCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARBusinessType WITH NOCHECK ADD 
CONSTRAINT TARBTBsTCode PRIMARY KEY CLUSTERED 
(
TARBTBsTCode,TARBTARNCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TARCampaign ALTER COLUMN TRCACode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARCampaign WITH NOCHECK ADD 
CONSTRAINT TRCACode PRIMARY KEY CLUSTERED 
(
TRCACode
) ON [PRIMARY]
GO

ALTER TABLE VS4TARCampaignBG ALTER COLUMN TRBGTRCACode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARCampaignBG WITH NOCHECK ADD 
CONSTRAINT TRBGTRCACode PRIMARY KEY CLUSTERED 
(
TRBGTRCACode
) ON [PRIMARY]
GO

ALTER TABLE VS4TARCampaignMB ALTER COLUMN TRCPTRCACode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARCampaignMB ALTER COLUMN TRCPLn SMALLINT NOT NULL 
GO

ALTER TABLE VS4TARCampaignMB WITH NOCHECK ADD 
CONSTRAINT TRCPTRCACode PRIMARY KEY CLUSTERED 
(
TRCPTRCACode,TRCPLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TARCard ALTER COLUMN TRICTARNCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARCard ALTER COLUMN TRICDocNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARCard ALTER COLUMN TRICType NVARCHAR (2) NOT NULL 
GO

ALTER TABLE VS4TARCard WITH NOCHECK ADD 
CONSTRAINT TRICTARNCode PRIMARY KEY CLUSTERED 
(
TRICTARNCode,TRICDocNo,TRICType
) ON [PRIMARY]
GO

ALTER TABLE VS4TARChild ALTER COLUMN TAChLn INT NOT NULL 
GO

ALTER TABLE VS4TARChild ALTER COLUMN TAChTARNCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARChild WITH NOCHECK ADD 
CONSTRAINT TAChLn PRIMARY KEY CLUSTERED 
(
TAChLn,TAChTARNCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TARContact ALTER COLUMN TARCCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARContact ALTER COLUMN TARCTARNCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARContact WITH NOCHECK ADD 
CONSTRAINT TARCCode PRIMARY KEY CLUSTERED 
(
TARCCode,TARCTARNCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TARContactInden ALTER COLUMN TIDCTARCTARNCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARContactInden ALTER COLUMN TIDCTARCCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARContactInden ALTER COLUMN TIDCLn INT NOT NULL 
GO

ALTER TABLE VS4TARContactInden WITH NOCHECK ADD 
CONSTRAINT TIDCTARCTARNCode PRIMARY KEY CLUSTERED 
(
TIDCTARCTARNCode,TIDCTARCCode,TIDCLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TARCreditCard ALTER COLUMN TACDTARNCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARCreditCard ALTER COLUMN TACDLn SMALLINT NOT NULL 
GO

ALTER TABLE VS4TARCreditCard WITH NOCHECK ADD 
CONSTRAINT TACDTARNCode PRIMARY KEY CLUSTERED 
(
TACDTARNCode,TACDLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TARCreditLimit ALTER COLUMN TRCLTARNCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARCreditLimit ALTER COLUMN TRCLStartDate DATETIME NOT NULL 
GO

ALTER TABLE VS4TARCreditLimit WITH NOCHECK ADD 
CONSTRAINT TRCLTARNCode PRIMARY KEY CLUSTERED 
(
TRCLTARNCode,TRCLStartDate
) ON [PRIMARY]
GO

ALTER TABLE VS4TARCreditNote ALTER COLUMN TRCNNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARCreditNote WITH NOCHECK ADD 
CONSTRAINT TRCNNo PRIMARY KEY CLUSTERED 
(
TRCNNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TARCreditNoteMB ALTER COLUMN TRCMLn INT NOT NULL 
GO

ALTER TABLE VS4TARCreditNoteMB ALTER COLUMN TRCMTRCNNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARCreditNoteMB WITH NOCHECK ADD 
CONSTRAINT TRCMLn PRIMARY KEY CLUSTERED 
(
TRCMLn,TRCMTRCNNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TARDebitNote ALTER COLUMN TDBNNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARDebitNote WITH NOCHECK ADD 
CONSTRAINT TDBNNo PRIMARY KEY CLUSTERED 
(
TDBNNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TARDebitNoteMB ALTER COLUMN TDBMLn INT NOT NULL 
GO

ALTER TABLE VS4TARDebitNoteMB ALTER COLUMN TDBMTDBNNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARDebitNoteMB WITH NOCHECK ADD 
CONSTRAINT TDBMLn PRIMARY KEY CLUSTERED 
(
TDBMLn,TDBMTDBNNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TARDebtAdjust ALTER COLUMN TRAJNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARDebtAdjust WITH NOCHECK ADD 
CONSTRAINT TRAJNo PRIMARY KEY CLUSTERED 
(
TRAJNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TARDebtAdjustMB ALTER COLUMN TRJMLn INT NOT NULL 
GO

ALTER TABLE VS4TARDebtAdjustMB ALTER COLUMN TRJMTRJANo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARDebtAdjustMB WITH NOCHECK ADD 
CONSTRAINT TRJMLn PRIMARY KEY CLUSTERED 
(
TRJMLn,TRJMTRJANo
) ON [PRIMARY]
GO

ALTER TABLE VS4TARGroup ALTER COLUMN TARGCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARGroup WITH NOCHECK ADD 
CONSTRAINT TARGCode PRIMARY KEY CLUSTERED 
(
TARGCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TARHolder ALTER COLUMN TARHCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARHolder WITH NOCHECK ADD 
CONSTRAINT TARHCode PRIMARY KEY CLUSTERED 
(
TARHCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TARImportantDay ALTER COLUMN TARITARNCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARImportantDay ALTER COLUMN TARILn INT NOT NULL 
GO

ALTER TABLE VS4TARImportantDay WITH NOCHECK ADD 
CONSTRAINT TARITARNCode PRIMARY KEY CLUSTERED 
(
TARITARNCode,TARILn
) ON [PRIMARY]
GO

ALTER TABLE VS4TARIndentify ALTER COLUMN TIDRTARNCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARIndentify ALTER COLUMN TIDRLn INT NOT NULL 
GO

ALTER TABLE VS4TARIndentify WITH NOCHECK ADD 
CONSTRAINT TIDRTARNCode PRIMARY KEY CLUSTERED 
(
TIDRTARNCode,TIDRLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TARInquiry ALTER COLUMN TAQCTARNCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARInquiry ALTER COLUMN TAQCLn INT NOT NULL 
GO

ALTER TABLE VS4TARInquiry WITH NOCHECK ADD 
CONSTRAINT TAQCTARNCode PRIMARY KEY CLUSTERED 
(
TAQCTARNCode,TAQCLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TARInvoice ALTER COLUMN TIvoNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARInvoice WITH NOCHECK ADD 
CONSTRAINT TIvoNo PRIMARY KEY CLUSTERED 
(
TIvoNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TARInvoiceADJ ALTER COLUMN TIvANo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARInvoiceADJ WITH NOCHECK ADD 
CONSTRAINT TIvANo PRIMARY KEY CLUSTERED 
(
TIvANo
) ON [PRIMARY]
GO

ALTER TABLE VS4TARInvoiceBook ALTER COLUMN TRBKCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARInvoiceBook WITH NOCHECK ADD 
CONSTRAINT TRBKCode PRIMARY KEY CLUSTERED 
(
TRBKCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TARInvoiceMB ALTER COLUMN TIoMLn INT NOT NULL 
GO

ALTER TABLE VS4TARInvoiceMB ALTER COLUMN TIoMTIvoNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARInvoiceMB WITH NOCHECK ADD 
CONSTRAINT TIoMLn PRIMARY KEY CLUSTERED 
(
TIoMLn,TIoMTIvoNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TARInvoicePay ALTER COLUMN TIPyTIvoNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARInvoicePay ALTER COLUMN TIPyLn INT NOT NULL 
GO

ALTER TABLE VS4TARInvoicePay WITH NOCHECK ADD 
CONSTRAINT TIPyTIvoNo PRIMARY KEY CLUSTERED 
(
TIPyTIvoNo,TIPyLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TARMedia ALTER COLUMN TAMdTMedCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARMedia ALTER COLUMN TAMdTARNCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARMedia WITH NOCHECK ADD 
CONSTRAINT TAMdTMedCode PRIMARY KEY CLUSTERED 
(
TAMdTMedCode,TAMdTARNCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TARMemberCard ALTER COLUMN TAMCTARNCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARMemberCard ALTER COLUMN TAMCLn SMALLINT NOT NULL 
GO

ALTER TABLE VS4TARMemberCard WITH NOCHECK ADD 
CONSTRAINT TAMCTARNCode PRIMARY KEY CLUSTERED 
(
TAMCTARNCode,TAMCLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TARParent ALTER COLUMN TARPTARNCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARParent ALTER COLUMN TARPTARNCode2 NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARParent WITH NOCHECK ADD 
CONSTRAINT TARPTARNCode PRIMARY KEY CLUSTERED 
(
TARPTARNCode,TARPTARNCode2
) ON [PRIMARY]
GO

ALTER TABLE VS4TARParentFamily ALTER COLUMN TAPFTARNCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARParentFamily ALTER COLUMN TAPFLn INT NOT NULL 
GO

ALTER TABLE VS4TARParentFamily WITH NOCHECK ADD 
CONSTRAINT TAPFTARNCode PRIMARY KEY CLUSTERED 
(
TAPFTARNCode,TAPFLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TARReceipt ALTER COLUMN TAIHNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARReceipt WITH NOCHECK ADD 
CONSTRAINT TAIHNo PRIMARY KEY CLUSTERED 
(
TAIHNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TARReceiptD ALTER COLUMN TAIRNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARReceiptD WITH NOCHECK ADD 
CONSTRAINT TAIRNo PRIMARY KEY CLUSTERED 
(
TAIRNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TARReceiptDMB ALTER COLUMN TRDMLn INT NOT NULL 
GO

ALTER TABLE VS4TARReceiptDMB ALTER COLUMN TRDMTAIRNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARReceiptDMB WITH NOCHECK ADD 
CONSTRAINT TRDMLn PRIMARY KEY CLUSTERED 
(
TRDMLn,TRDMTAIRNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TARReceiptMB ALTER COLUMN TREMTAIHNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARReceiptMB ALTER COLUMN TREMLn INT NOT NULL 
GO

ALTER TABLE VS4TARReceiptMB WITH NOCHECK ADD 
CONSTRAINT TREMTAIHNo PRIMARY KEY CLUSTERED 
(
TREMTAIHNo,TREMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TARReceiptMBD ALTER COLUMN TRBDTREMTAIHNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARReceiptMBD ALTER COLUMN TRBDTREMLn INT NOT NULL 
GO

ALTER TABLE VS4TARReceiptMBD ALTER COLUMN TRBDLn INT NOT NULL 
GO

ALTER TABLE VS4TARReceiptMBD WITH NOCHECK ADD 
CONSTRAINT TRBDTREMTAIHNo PRIMARY KEY CLUSTERED 
(
TRBDTREMTAIHNo,TRBDTREMLn,TRBDLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TARShippingMark ALTER COLUMN TRSMLn INT NOT NULL 
GO

ALTER TABLE VS4TARShippingMark ALTER COLUMN TRSMTARNCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARShippingMark WITH NOCHECK ADD 
CONSTRAINT TRSMLn PRIMARY KEY CLUSTERED 
(
TRSMLn,TRSMTARNCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TARStatus ALTER COLUMN TARSAlias NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARStatus WITH NOCHECK ADD 
CONSTRAINT TARSAlias PRIMARY KEY CLUSTERED 
(
TARSAlias
) ON [PRIMARY]
GO

ALTER TABLE VS4TARType ALTER COLUMN TARTCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARType WITH NOCHECK ADD 
CONSTRAINT TARTCode PRIMARY KEY CLUSTERED 
(
TARTCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TARVandReceipt ALTER COLUMN TRNRTRVHNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARVandReceipt ALTER COLUMN TRNRTRECNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARVandReceipt WITH NOCHECK ADD 
CONSTRAINT TRNRTRVHNo PRIMARY KEY CLUSTERED 
(
TRNRTRVHNo,TRNRTRECNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TARVDocRef ALTER COLUMN TRDRTRVHNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARVDocRef ALTER COLUMN TRDRLn INT NOT NULL 
GO

ALTER TABLE VS4TARVDocRef WITH NOCHECK ADD 
CONSTRAINT TRDRTRVHNo PRIMARY KEY CLUSTERED 
(
TRDRTRVHNo,TRDRLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TARVDocRefMB ALTER COLUMN TRVMTRDRTRVHNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARVDocRefMB ALTER COLUMN TRVMTRDRLn INT NOT NULL 
GO

ALTER TABLE VS4TARVDocRefMB ALTER COLUMN TRVMLn INT NOT NULL 
GO

ALTER TABLE VS4TARVDocRefMB WITH NOCHECK ADD 
CONSTRAINT TRVMTRDRTRVHNo PRIMARY KEY CLUSTERED 
(
TRVMTRDRTRVHNo,TRVMTRDRLn,TRVMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TARVoucher ALTER COLUMN TRVHNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARVoucher WITH NOCHECK ADD 
CONSTRAINT TRVHNo PRIMARY KEY CLUSTERED 
(
TRVHNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TARVoucherPay ALTER COLUMN TRVRTRVHNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TARVoucherPay ALTER COLUMN TRVRLn INT NOT NULL 
GO

ALTER TABLE VS4TARVoucherPay WITH NOCHECK ADD 
CONSTRAINT TRVRTRVHNo PRIMARY KEY CLUSTERED 
(
TRVRTRVHNo,TRVRLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TAsset ALTER COLUMN TAssCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAsset WITH NOCHECK ADD 
CONSTRAINT TAssCode PRIMARY KEY CLUSTERED 
(
TAssCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TAsset2Alias ALTER COLUMN TA2ATAssCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAsset2Alias ALTER COLUMN TA2ATAsACode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAsset2Alias WITH NOCHECK ADD 
CONSTRAINT TA2ATAssCode PRIMARY KEY CLUSTERED 
(
TA2ATAssCode,TA2ATAsACode
) ON [PRIMARY]
GO

ALTER TABLE VS4TAssetAlias ALTER COLUMN TAsACode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAssetAlias WITH NOCHECK ADD 
CONSTRAINT TAsACode PRIMARY KEY CLUSTERED 
(
TAsACode
) ON [PRIMARY]
GO

ALTER TABLE VS4TAssetAllocate ALTER COLUMN TAsATAssCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAssetAllocate ALTER COLUMN TAsALn INT NOT NULL 
GO

ALTER TABLE VS4TAssetAllocate WITH NOCHECK ADD 
CONSTRAINT TAsATAssCode PRIMARY KEY CLUSTERED 
(
TAsATAssCode,TAsALn
) ON [PRIMARY]
GO

ALTER TABLE VS4TAssetBuiltReq ALTER COLUMN TBRqNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAssetBuiltReq WITH NOCHECK ADD 
CONSTRAINT TBRqNo PRIMARY KEY CLUSTERED 
(
TBRqNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TAssetCalcType ALTER COLUMN TACTAlias NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAssetCalcType WITH NOCHECK ADD 
CONSTRAINT TACTAlias PRIMARY KEY CLUSTERED 
(
TACTAlias
) ON [PRIMARY]
GO

ALTER TABLE VS4TAssetFix ALTER COLUMN TFstNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAssetFix WITH NOCHECK ADD 
CONSTRAINT TFstNo PRIMARY KEY CLUSTERED 
(
TFstNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TAssetFixCCL ALTER COLUMN TCCLTFITCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAssetFixCCL ALTER COLUMN TCCLLn INT NOT NULL 
GO

ALTER TABLE VS4TAssetFixCCL WITH NOCHECK ADD 
CONSTRAINT TCCLTFITCode PRIMARY KEY CLUSTERED 
(
TCCLTFITCode,TCCLLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TAssetFixMB ALTER COLUMN TFSbTFstNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAssetFixMB ALTER COLUMN TFSbLn INT NOT NULL 
GO

ALTER TABLE VS4TAssetFixMB WITH NOCHECK ADD 
CONSTRAINT TFSbTFstNo PRIMARY KEY CLUSTERED 
(
TFSbTFstNo,TFSbLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TAssetFixMethod ALTER COLUMN TCCMCode NVARCHAR (1) NOT NULL 
GO

ALTER TABLE VS4TAssetFixMethod WITH NOCHECK ADD 
CONSTRAINT TCCMCode PRIMARY KEY CLUSTERED 
(
TCCMCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TAssetFixReq ALTER COLUMN TFRqNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAssetFixReq WITH NOCHECK ADD 
CONSTRAINT TFRqNo PRIMARY KEY CLUSTERED 
(
TFRqNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TAssetFixSub ALTER COLUMN TFssTFstNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAssetFixSub ALTER COLUMN TFssLn INT NOT NULL 
GO

ALTER TABLE VS4TAssetFixSub WITH NOCHECK ADD 
CONSTRAINT TFssTFstNo PRIMARY KEY CLUSTERED 
(
TFssTFstNo,TFssLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TAssetFixTool ALTER COLUMN TCCTCode NVARCHAR (2) NOT NULL 
GO

ALTER TABLE VS4TAssetFixTool WITH NOCHECK ADD 
CONSTRAINT TCCTCode PRIMARY KEY CLUSTERED 
(
TCCTCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TAssetFixType ALTER COLUMN TFITCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAssetFixType WITH NOCHECK ADD 
CONSTRAINT TFITCode PRIMARY KEY CLUSTERED 
(
TFITCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TAssetFund ALTER COLUMN TAFdTAssCode NVARCHAR (50) NOT NULL 
GO

ALTER TABLE VS4TAssetFund ALTER COLUMN TAFdLn INT NOT NULL 
GO

ALTER TABLE VS4TAssetFund WITH NOCHECK ADD 
CONSTRAINT TAFdTAssCode PRIMARY KEY CLUSTERED 
(
TAFdTAssCode,TAFdLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TAssetFundType ALTER COLUMN TAFtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAssetFundType WITH NOCHECK ADD 
CONSTRAINT TAFtCode PRIMARY KEY CLUSTERED 
(
TAFtCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TAssetImage ALTER COLUMN TAsITAssCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAssetImage ALTER COLUMN TAsICode INT NOT NULL 
GO

ALTER TABLE VS4TAssetImage WITH NOCHECK ADD 
CONSTRAINT TAsITAssCode PRIMARY KEY CLUSTERED 
(
TAsITAssCode,TAsICode
) ON [PRIMARY]
GO

ALTER TABLE VS4TAssetMB ALTER COLUMN TAsbTAssCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAssetMB ALTER COLUMN TAsbTAssCode2 NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAssetMB WITH NOCHECK ADD 
CONSTRAINT TAsbTAssCode PRIMARY KEY CLUSTERED 
(
TAsbTAssCode,TAsbTAssCode2
) ON [PRIMARY]
GO

ALTER TABLE VS4TAssetPeriod ALTER COLUMN TAPeTAssCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAssetPeriod ALTER COLUMN TAPePeriodNo INT NOT NULL 
GO

ALTER TABLE VS4TAssetPeriod WITH NOCHECK ADD 
CONSTRAINT TAPeTAssCode PRIMARY KEY CLUSTERED 
(
TAPeTAssCode,TAPePeriodNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TAssetPeriodSub ALTER COLUMN TSPbTAssCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAssetPeriodSub ALTER COLUMN TSPbYear INT NOT NULL 
GO

ALTER TABLE VS4TAssetPeriodSub ALTER COLUMN TSPbMonth INT NOT NULL 
GO

ALTER TABLE VS4TAssetPeriodSub ALTER COLUMN TSPbLn INT NOT NULL 
GO

ALTER TABLE VS4TAssetPeriodSub WITH NOCHECK ADD 
CONSTRAINT TSPbTAssCode PRIMARY KEY CLUSTERED 
(
TSPbTAssCode,TSPbYear,TSPbMonth,TSPbLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TAssetPlan ALTER COLUMN TASPTAFPNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAssetPlan ALTER COLUMN TASPYear INT NOT NULL 
GO

ALTER TABLE VS4TAssetPlan ALTER COLUMN TASPMonth INT NOT NULL 
GO

ALTER TABLE VS4TAssetPlan ALTER COLUMN TASPWeek INT NOT NULL 
GO

ALTER TABLE VS4TAssetPlan ALTER COLUMN TASPLn INT NOT NULL 
GO

ALTER TABLE VS4TAssetPlan WITH NOCHECK ADD 
CONSTRAINT TASPTAFPNo PRIMARY KEY CLUSTERED 
(
TASPTAFPNo,TASPYear,TASPMonth,TASPWeek,TASPLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TAssetPlanMain ALTER COLUMN TAPMTAFPNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAssetPlanMain ALTER COLUMN TAPMYear INT NOT NULL 
GO

ALTER TABLE VS4TAssetPlanMain WITH NOCHECK ADD 
CONSTRAINT TAPMTAFPNo PRIMARY KEY CLUSTERED 
(
TAPMTAFPNo,TAPMYear
) ON [PRIMARY]
GO

ALTER TABLE VS4TAssetPM ALTER COLUMN TAFPNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAssetPM WITH NOCHECK ADD 
CONSTRAINT TAFPNo PRIMARY KEY CLUSTERED 
(
TAFPNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TAssetPMMB ALTER COLUMN TAFBTAFPNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAssetPMMB ALTER COLUMN TAFBLn INT NOT NULL 
GO

ALTER TABLE VS4TAssetPMMB WITH NOCHECK ADD 
CONSTRAINT TAFBTAFPNo PRIMARY KEY CLUSTERED 
(
TAFBTAFPNo,TAFBLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TAssetSection ALTER COLUMN TAseCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAssetSection WITH NOCHECK ADD 
CONSTRAINT TAseCode PRIMARY KEY CLUSTERED 
(
TAseCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TAssetSub ALTER COLUMN TASuID INT NOT NULL 
GO

ALTER TABLE VS4TAssetSub WITH NOCHECK ADD 
CONSTRAINT TASuID PRIMARY KEY CLUSTERED 
(
TASuID
) ON [PRIMARY]
GO

ALTER TABLE VS4TAssetTrans ALTER COLUMN TATfNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAssetTrans WITH NOCHECK ADD 
CONSTRAINT TATfNo PRIMARY KEY CLUSTERED 
(
TATfNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TAssetTransMB ALTER COLUMN TATMTATfNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAssetTransMB ALTER COLUMN TATMLn INT NOT NULL 
GO

ALTER TABLE VS4TAssetTransMB WITH NOCHECK ADD 
CONSTRAINT TATMTATfNo PRIMARY KEY CLUSTERED 
(
TATMTATfNo,TATMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TAssetTransType ALTER COLUMN TATTAlias NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAssetTransType WITH NOCHECK ADD 
CONSTRAINT TATTAlias PRIMARY KEY CLUSTERED 
(
TATTAlias
) ON [PRIMARY]
GO

ALTER TABLE VS4TAssetType ALTER COLUMN TAsTCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAssetType WITH NOCHECK ADD 
CONSTRAINT TAsTCode PRIMARY KEY CLUSTERED 
(
TAsTCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TAssetWGMB ALTER COLUMN TAegTAgtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAssetWGMB ALTER COLUMN TAegTAssCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAssetWGMB WITH NOCHECK ADD 
CONSTRAINT TAegTAgtCode PRIMARY KEY CLUSTERED 
(
TAegTAgtCode,TAegTAssCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TAssetWorkGroup ALTER COLUMN TAgtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAssetWorkGroup WITH NOCHECK ADD 
CONSTRAINT TAgtCode PRIMARY KEY CLUSTERED 
(
TAgtCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TAssetWorkTime ALTER COLUMN TEntTAssCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TAssetWorkTime ALTER COLUMN TEntLn INT NOT NULL 
GO

ALTER TABLE VS4TAssetWorkTime WITH NOCHECK ADD 
CONSTRAINT TEntTAssCode PRIMARY KEY CLUSTERED 
(
TEntTAssCode,TEntLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TBank ALTER COLUMN TBnkCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TBank WITH NOCHECK ADD 
CONSTRAINT TBnkCode PRIMARY KEY CLUSTERED 
(
TBnkCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TBankAccType ALTER COLUMN TBATID REAL NOT NULL 
GO

ALTER TABLE VS4TBankAccType WITH NOCHECK ADD 
CONSTRAINT TBATID PRIMARY KEY CLUSTERED 
(
TBATID
) ON [PRIMARY]
GO

ALTER TABLE VS4TBankBranch ALTER COLUMN TBBrCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TBankBranch WITH NOCHECK ADD 
CONSTRAINT TBBrCode PRIMARY KEY CLUSTERED 
(
TBBrCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TBankCardFee ALTER COLUMN TBCFTBnkCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TBankCardFee ALTER COLUMN TBCFTPymCode NVARCHAR (15) NOT NULL 
GO

ALTER TABLE VS4TBankCardFee ALTER COLUMN TBCFCardBank NVARCHAR (15) NOT NULL 
GO

ALTER TABLE VS4TBankCardFee WITH NOCHECK ADD 
CONSTRAINT TBCFTBnkCode PRIMARY KEY CLUSTERED 
(
TBCFTBnkCode,TBCFTPymCode,TBCFCardBank
) ON [PRIMARY]
GO

ALTER TABLE VS4TBankCheque ALTER COLUMN TBCqCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TBankCheque WITH NOCHECK ADD 
CONSTRAINT TBCqCode PRIMARY KEY CLUSTERED 
(
TBCqCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TBankCreditCard ALTER COLUMN TBCDNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TBankCreditCard WITH NOCHECK ADD 
CONSTRAINT TBCDNo PRIMARY KEY CLUSTERED 
(
TBCDNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TBankHoliday ALTER COLUMN TBHdHolidayDate DATETIME NOT NULL 
GO

ALTER TABLE VS4TBankHoliday WITH NOCHECK ADD 
CONSTRAINT TBHdHolidayDate PRIMARY KEY CLUSTERED 
(
TBHdHolidayDate
) ON [PRIMARY]
GO

ALTER TABLE VS4TBankSlip ALTER COLUMN TBSLCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TBankSlip WITH NOCHECK ADD 
CONSTRAINT TBSLCode PRIMARY KEY CLUSTERED 
(
TBSLCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TBOQ ALTER COLUMN TBOQNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TBOQ WITH NOCHECK ADD 
CONSTRAINT TBOQNo PRIMARY KEY CLUSTERED 
(
TBOQNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TBOQBook ALTER COLUMN TBQkCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TBOQBook WITH NOCHECK ADD 
CONSTRAINT TBQkCode PRIMARY KEY CLUSTERED 
(
TBQkCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TBOQDL ALTER COLUMN TBQLTBQBTBOQNo NVARCHAR (50) NOT NULL 
GO

ALTER TABLE VS4TBOQDL ALTER COLUMN TBQLTBQBLn INT NOT NULL 
GO

ALTER TABLE VS4TBOQDL ALTER COLUMN TBQLTSpdStep INT NOT NULL 
GO

ALTER TABLE VS4TBOQDL ALTER COLUMN TBQLLn INT NOT NULL 
GO

ALTER TABLE VS4TBOQDL WITH NOCHECK ADD 
CONSTRAINT TBQLTBQBTBOQNo PRIMARY KEY CLUSTERED 
(
TBQLTBQBTBOQNo,TBQLTBQBLn,TBQLTSpdStep,TBQLLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TBOQMaterial ALTER COLUMN TBQMTBQBTBOQNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TBOQMaterial ALTER COLUMN TBQMTBQBLn INT NOT NULL 
GO

ALTER TABLE VS4TBOQMaterial ALTER COLUMN TBQMTSpdStep INT NOT NULL 
GO

ALTER TABLE VS4TBOQMaterial ALTER COLUMN TBQMLn INT NOT NULL 
GO

ALTER TABLE VS4TBOQMaterial WITH NOCHECK ADD 
CONSTRAINT TBQMTBQBTBOQNo PRIMARY KEY CLUSTERED 
(
TBQMTBQBTBOQNo,TBQMTBQBLn,TBQMTSpdStep,TBQMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TBOQMB ALTER COLUMN TBQBTBOQNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TBOQMB ALTER COLUMN TBQBLn INT NOT NULL 
GO

ALTER TABLE VS4TBOQMB WITH NOCHECK ADD 
CONSTRAINT TBQBTBOQNo PRIMARY KEY CLUSTERED 
(
TBQBTBOQNo,TBQBLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TBOQMethod ALTER COLUMN TBQRTBQBTBOQNo NVARCHAR (50) NOT NULL 
GO

ALTER TABLE VS4TBOQMethod ALTER COLUMN TBQRTBQBLn INT NOT NULL 
GO

ALTER TABLE VS4TBOQMethod ALTER COLUMN TBQRTSpdStep INT NOT NULL 
GO

ALTER TABLE VS4TBOQMethod ALTER COLUMN TBQRLn INT NOT NULL 
GO

ALTER TABLE VS4TBOQMethod WITH NOCHECK ADD 
CONSTRAINT TBQRTBQBTBOQNo PRIMARY KEY CLUSTERED 
(
TBQRTBQBTBOQNo,TBQRTBQBLn,TBQRTSpdStep,TBQRLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TBranch ALTER COLUMN TBraCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TBranch WITH NOCHECK ADD 
CONSTRAINT TBraCode PRIMARY KEY CLUSTERED 
(
TBraCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TBranchGroup ALTER COLUMN TBrGCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TBranchGroup WITH NOCHECK ADD 
CONSTRAINT TBrGCode PRIMARY KEY CLUSTERED 
(
TBrGCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TBranchGroupMB ALTER COLUMN TBGMTBrGCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TBranchGroupMB ALTER COLUMN TBGMTBraCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TBranchGroupMB WITH NOCHECK ADD 
CONSTRAINT TBGMTBrGCode PRIMARY KEY CLUSTERED 
(
TBGMTBrGCode,TBGMTBraCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TBranchSign ALTER COLUMN TBrSTBraCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TBranchSign ALTER COLUMN TBrSLn NVARCHAR (255) NOT NULL 
GO

ALTER TABLE VS4TBranchSign WITH NOCHECK ADD 
CONSTRAINT TBrSTBraCode PRIMARY KEY CLUSTERED 
(
TBrSTBraCode,TBrSLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TBranchType ALTER COLUMN TBrTAlias NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TBranchType WITH NOCHECK ADD 
CONSTRAINT TBrTAlias PRIMARY KEY CLUSTERED 
(
TBrTAlias
) ON [PRIMARY]
GO

ALTER TABLE VS4TBrand ALTER COLUMN TBndCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TBrand WITH NOCHECK ADD 
CONSTRAINT TBndCode PRIMARY KEY CLUSTERED 
(
TBndCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TBrandGroup ALTER COLUMN TBnGCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TBrandGroup WITH NOCHECK ADD 
CONSTRAINT TBnGCode PRIMARY KEY CLUSTERED 
(
TBnGCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TBrandType ALTER COLUMN TBnTCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TBrandType WITH NOCHECK ADD 
CONSTRAINT TBnTCode PRIMARY KEY CLUSTERED 
(
TBnTCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TBudget ALTER COLUMN TBDGNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TBudget WITH NOCHECK ADD 
CONSTRAINT TBDGNo PRIMARY KEY CLUSTERED 
(
TBDGNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TBudgetMB ALTER COLUMN TBDMTBDGNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TBudgetMB ALTER COLUMN TBDMLn INT NOT NULL 
GO

ALTER TABLE VS4TBudgetMB WITH NOCHECK ADD 
CONSTRAINT TBDMTBDGNo PRIMARY KEY CLUSTERED 
(
TBDMTBDGNo,TBDMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TBusinessFlow ALTER COLUMN TBsFCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TBusinessFlow WITH NOCHECK ADD 
CONSTRAINT TBsFCode PRIMARY KEY CLUSTERED 
(
TBsFCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TBusinessFlowMB ALTER COLUMN TBFMTBsFCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TBusinessFlowMB ALTER COLUMN TBFMTLn INT NOT NULL 
GO

ALTER TABLE VS4TBusinessFlowMB WITH NOCHECK ADD 
CONSTRAINT TBFMTBsFCode PRIMARY KEY CLUSTERED 
(
TBFMTBsFCode,TBFMTLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TBusinessMajor ALTER COLUMN TBsMCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TBusinessMajor WITH NOCHECK ADD 
CONSTRAINT TBsMCode PRIMARY KEY CLUSTERED 
(
TBsMCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TBusinessType ALTER COLUMN TBsTCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TBusinessType WITH NOCHECK ADD 
CONSTRAINT TBsTCode PRIMARY KEY CLUSTERED 
(
TBsTCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TCapacityMG ALTER COLUMN TCPMTAgtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TCapacityMG ALTER COLUMN TCPMYear INT NOT NULL 
GO

ALTER TABLE VS4TCapacityMG ALTER COLUMN TCPMWeek INT NOT NULL 
GO

ALTER TABLE VS4TCapacityMG WITH NOCHECK ADD 
CONSTRAINT TCPMTAgtCode PRIMARY KEY CLUSTERED 
(
TCPMTAgtCode,TCPMYear,TCPMWeek
) ON [PRIMARY]
GO

ALTER TABLE VS4TCapacitySect ALTER COLUMN TCPSTSecCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TCapacitySect ALTER COLUMN TCPSYear INT NOT NULL 
GO

ALTER TABLE VS4TCapacitySect ALTER COLUMN TCPSWeek INT NOT NULL 
GO

ALTER TABLE VS4TCapacitySect WITH NOCHECK ADD 
CONSTRAINT TCPSTSecCode PRIMARY KEY CLUSTERED 
(
TCPSTSecCode,TCPSYear,TCPSWeek
) ON [PRIMARY]
GO

ALTER TABLE VS4TCashDeposit ALTER COLUMN TDPSNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TCashDeposit WITH NOCHECK ADD 
CONSTRAINT TDPSNo PRIMARY KEY CLUSTERED 
(
TDPSNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TCashDepositMB ALTER COLUMN TDPMTDPSNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TCashDepositMB ALTER COLUMN TDPMLn INT NOT NULL 
GO

ALTER TABLE VS4TCashDepositMB WITH NOCHECK ADD 
CONSTRAINT TDPMTDPSNo PRIMARY KEY CLUSTERED 
(
TDPMTDPSNo,TDPMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TCashRequest ALTER COLUMN TCRQNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TCashRequest WITH NOCHECK ADD 
CONSTRAINT TCRQNo PRIMARY KEY CLUSTERED 
(
TCRQNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TCashRequestMB ALTER COLUMN TCRMTCRQNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TCashRequestMB ALTER COLUMN TCRMLn INT NOT NULL 
GO

ALTER TABLE VS4TCashRequestMB WITH NOCHECK ADD 
CONSTRAINT TCRMTCRQNo PRIMARY KEY CLUSTERED 
(
TCRMTCRQNo,TCRMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TCategory ALTER COLUMN TCatCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TCategory WITH NOCHECK ADD 
CONSTRAINT TCatCode PRIMARY KEY CLUSTERED 
(
TCatCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TCategoryMB ALTER COLUMN TCaMTPOSCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TCategoryMB ALTER COLUMN TCaMTCatCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TCategoryMB WITH NOCHECK ADD 
CONSTRAINT TCaMTPOSCode PRIMARY KEY CLUSTERED 
(
TCaMTPOSCode,TCaMTCatCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TCategoryMBDwg ALTER COLUMN TCaDTDwgCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TCategoryMBDwg ALTER COLUMN TCaDTCatCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TCategoryMBDwg WITH NOCHECK ADD 
CONSTRAINT TCaDTDwgCode PRIMARY KEY CLUSTERED 
(
TCaDTDwgCode,TCaDTCatCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TCertificate ALTER COLUMN TCerNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TCertificate WITH NOCHECK ADD 
CONSTRAINT TCerNo PRIMARY KEY CLUSTERED 
(
TCerNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TCertificateSub ALTER COLUMN TCeMTCerNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TCertificateSub ALTER COLUMN TCeMLn INT NOT NULL 
GO

ALTER TABLE VS4TCertificateSub WITH NOCHECK ADD 
CONSTRAINT TCeMTCerNo PRIMARY KEY CLUSTERED 
(
TCeMTCerNo,TCeMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TChequeBackType ALTER COLUMN TCQBCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TChequeBackType WITH NOCHECK ADD 
CONSTRAINT TCQBCode PRIMARY KEY CLUSTERED 
(
TCQBCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TChequeRec ALTER COLUMN TCHRNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TChequeRec WITH NOCHECK ADD 
CONSTRAINT TCHRNo PRIMARY KEY CLUSTERED 
(
TCHRNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TChequeRec2IV ALTER COLUMN TR2ITCHRNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TChequeRec2IV ALTER COLUMN TR2ITIPyTIvoNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TChequeRec2IV ALTER COLUMN TR2ITIPyLn INT NOT NULL 
GO

ALTER TABLE VS4TChequeRec2IV WITH NOCHECK ADD 
CONSTRAINT TR2ITCHRNo PRIMARY KEY CLUSTERED 
(
TR2ITCHRNo,TR2ITIPyTIvoNo,TR2ITIPyLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TChequeRec2POS ALTER COLUMN TR2PTCHRNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TChequeRec2POS ALTER COLUMN TR2PTPPyTPTANo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TChequeRec2POS ALTER COLUMN TR2PTPPyLn INT NOT NULL 
GO

ALTER TABLE VS4TChequeRec2POS WITH NOCHECK ADD 
CONSTRAINT TR2PTCHRNo PRIMARY KEY CLUSTERED 
(
TR2PTCHRNo,TR2PTPPyTPTANo,TR2PTPPyLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TChequeRec2RV ALTER COLUMN TR2RTCHRNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TChequeRec2RV ALTER COLUMN TR2RTRVRTRVHNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TChequeRec2RV ALTER COLUMN TR2RTRVRLn INT NOT NULL 
GO

ALTER TABLE VS4TChequeRec2RV WITH NOCHECK ADD 
CONSTRAINT TR2RTCHRNo PRIMARY KEY CLUSTERED 
(
TR2RTCHRNo,TR2RTRVRTRVHNo,TR2RTRVRLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TChequeSub ALTER COLUMN TCHSNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TChequeSub WITH NOCHECK ADD 
CONSTRAINT TCHSNo PRIMARY KEY CLUSTERED 
(
TCHSNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TChequeSub2IV ALTER COLUMN TS2ITCHSNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TChequeSub2IV ALTER COLUMN TS2ITPIPTIAPNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TChequeSub2IV ALTER COLUMN TS2ITPIPLn INT NOT NULL 
GO

ALTER TABLE VS4TChequeSub2IV WITH NOCHECK ADD 
CONSTRAINT TS2ITCHSNo PRIMARY KEY CLUSTERED 
(
TS2ITCHSNo,TS2ITPIPTIAPNo,TS2ITPIPLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TChequeSub2PV ALTER COLUMN TS2PTCHSNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TChequeSub2PV ALTER COLUMN TS2PTPVPTAPVNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TChequeSub2PV ALTER COLUMN TS2PTPVPLn INT NOT NULL 
GO

ALTER TABLE VS4TChequeSub2PV WITH NOCHECK ADD 
CONSTRAINT TS2PTCHSNo PRIMARY KEY CLUSTERED 
(
TS2PTCHSNo,TS2PTPVPTAPVNo,TS2PTPVPLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TCode ALTER COLUMN TCodAlias NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TCode WITH NOCHECK ADD 
CONSTRAINT TCodAlias PRIMARY KEY CLUSTERED 
(
TCodAlias
) ON [PRIMARY]
GO

ALTER TABLE VS4TCodeGroup ALTER COLUMN TCoGAlias NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TCodeGroup WITH NOCHECK ADD 
CONSTRAINT TCoGAlias PRIMARY KEY CLUSTERED 
(
TCoGAlias
) ON [PRIMARY]
GO

ALTER TABLE VS4TCommand ALTER COLUMN TCmdID INT NOT NULL 
GO

ALTER TABLE VS4TCommand WITH NOCHECK ADD 
CONSTRAINT TCmdID PRIMARY KEY CLUSTERED 
(
TCmdID
) ON [PRIMARY]
GO

ALTER TABLE VS4TCommandGroup ALTER COLUMN TCmGAlias NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TCommandGroup WITH NOCHECK ADD 
CONSTRAINT TCmGAlias PRIMARY KEY CLUSTERED 
(
TCmGAlias
) ON [PRIMARY]
GO

ALTER TABLE VS4TCommission ALTER COLUMN TComNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TCommission WITH NOCHECK ADD 
CONSTRAINT TComNo PRIMARY KEY CLUSTERED 
(
TComNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TCommissionSub ALTER COLUMN TCmrTComNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TCommissionSub ALTER COLUMN TCmrLn SMALLINT NOT NULL 
GO

ALTER TABLE VS4TCommissionSub WITH NOCHECK ADD 
CONSTRAINT TCmrTComNo PRIMARY KEY CLUSTERED 
(
TCmrTComNo,TCmrLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TCommissor ALTER COLUMN TCmsCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TCommissor WITH NOCHECK ADD 
CONSTRAINT TCmsCode PRIMARY KEY CLUSTERED 
(
TCmsCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TCommissorAP ALTER COLUMN TCAPTCmsCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TCommissorAP ALTER COLUMN TCAPTAPNCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TCommissorAP WITH NOCHECK ADD 
CONSTRAINT TCAPTCmsCode PRIMARY KEY CLUSTERED 
(
TCAPTCmsCode,TCAPTAPNCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TCommissorAR ALTER COLUMN TCARTCmsCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TCommissorAR ALTER COLUMN TCARTAPNCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TCommissorAR WITH NOCHECK ADD 
CONSTRAINT TCARTCmsCode PRIMARY KEY CLUSTERED 
(
TCARTCmsCode,TCARTAPNCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TCommissorEMP ALTER COLUMN TCEPTCmsCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TCommissorEMP ALTER COLUMN TCEPTEmpCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TCommissorEMP WITH NOCHECK ADD 
CONSTRAINT TCEPTCmsCode PRIMARY KEY CLUSTERED 
(
TCEPTCmsCode,TCEPTEmpCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TCommissorType ALTER COLUMN TCmTCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TCommissorType WITH NOCHECK ADD 
CONSTRAINT TCmTCode PRIMARY KEY CLUSTERED 
(
TCmTCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TCompany ALTER COLUMN TCmpCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TCompany WITH NOCHECK ADD 
CONSTRAINT TCmpCode PRIMARY KEY CLUSTERED 
(
TCmpCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TCompanyAddess ALTER COLUMN TCPATCmpCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TCompanyAddess ALTER COLUMN TCPALn INT NOT NULL 
GO

ALTER TABLE VS4TCompanyAddess WITH NOCHECK ADD 
CONSTRAINT TCPATCmpCode PRIMARY KEY CLUSTERED 
(
TCPATCmpCode,TCPALn
) ON [PRIMARY]
GO

ALTER TABLE VS4TCompanyBank ALTER COLUMN TCBBNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TCompanyBank WITH NOCHECK ADD 
CONSTRAINT TCBBNo PRIMARY KEY CLUSTERED 
(
TCBBNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TCompanyBusType ALTER COLUMN TCTYTBsTCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TCompanyBusType ALTER COLUMN TCTYTCmpCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TCompanyBusType WITH NOCHECK ADD 
CONSTRAINT TCTYTBsTCode PRIMARY KEY CLUSTERED 
(
TCTYTBsTCode,TCTYTCmpCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TCompanyContact ALTER COLUMN TCpCCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TCompanyContact ALTER COLUMN TCpCTCmpCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TCompanyContact WITH NOCHECK ADD 
CONSTRAINT TCpCCode PRIMARY KEY CLUSTERED 
(
TCpCCode,TCpCTCmpCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TCompetitor ALTER COLUMN TCptCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TCompetitor WITH NOCHECK ADD 
CONSTRAINT TCptCode PRIMARY KEY CLUSTERED 
(
TCptCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TCompetSection ALTER COLUMN TCPSTCPTCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TCompetSection ALTER COLUMN TCPSCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TCompetSection WITH NOCHECK ADD 
CONSTRAINT TCPSTCPTCode PRIMARY KEY CLUSTERED 
(
TCPSTCPTCode,TCPSCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TComSale ALTER COLUMN TCosNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TComSale WITH NOCHECK ADD 
CONSTRAINT TCosNo PRIMARY KEY CLUSTERED 
(
TCosNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TComSaleMB ALTER COLUMN TCsBLn INT NOT NULL 
GO

ALTER TABLE VS4TComSaleMB ALTER COLUMN TCsBTCosNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TComSaleMB WITH NOCHECK ADD 
CONSTRAINT TCsBLn PRIMARY KEY CLUSTERED 
(
TCsBLn,TCsBTCosNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TConComment ALTER COLUMN TCnCCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TConComment WITH NOCHECK ADD 
CONSTRAINT TCnCCode PRIMARY KEY CLUSTERED 
(
TCnCCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TContact ALTER COLUMN TCntNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TContact WITH NOCHECK ADD 
CONSTRAINT TCntNo PRIMARY KEY CLUSTERED 
(
TCntNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TContactMB ALTER COLUMN TCnMLn INT NOT NULL 
GO

ALTER TABLE VS4TContactMB ALTER COLUMN TCnMTCntNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TContactMB WITH NOCHECK ADD 
CONSTRAINT TCnMLn PRIMARY KEY CLUSTERED 
(
TCnMLn,TCnMTCntNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TContactType ALTER COLUMN TCcTCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TContactType WITH NOCHECK ADD 
CONSTRAINT TCcTCode PRIMARY KEY CLUSTERED 
(
TCcTCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TContinent ALTER COLUMN TCTNCode NVARCHAR (3) NOT NULL 
GO

ALTER TABLE VS4TContinent WITH NOCHECK ADD 
CONSTRAINT TCTNCode PRIMARY KEY CLUSTERED 
(
TCTNCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TCountry ALTER COLUMN TCouCode NVARCHAR (3) NOT NULL 
GO

ALTER TABLE VS4TCountry WITH NOCHECK ADD 
CONSTRAINT TCouCode PRIMARY KEY CLUSTERED 
(
TCouCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TCreditNoteType ALTER COLUMN TCRTCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TCreditNoteType WITH NOCHECK ADD 
CONSTRAINT TCRTCode PRIMARY KEY CLUSTERED 
(
TCRTCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TCreditTerm ALTER COLUMN TCdTCode NVARCHAR (10) NOT NULL 
GO

ALTER TABLE VS4TCreditTerm WITH NOCHECK ADD 
CONSTRAINT TCdTCode PRIMARY KEY CLUSTERED 
(
TCdTCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TCurrency ALTER COLUMN TCurCode NVARCHAR (5) NOT NULL 
GO

ALTER TABLE VS4TCurrency WITH NOCHECK ADD 
CONSTRAINT TCurCode PRIMARY KEY CLUSTERED 
(
TCurCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TCustom ALTER COLUMN TCsmCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TCustom ALTER COLUMN TCsmRefCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TCustom WITH NOCHECK ADD 
CONSTRAINT TCsmCode PRIMARY KEY CLUSTERED 
(
TCsmCode,TCsmRefCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TCustom1 ALTER COLUMN TCS1Type NVARCHAR (10) NOT NULL 
GO

ALTER TABLE VS4TCustom1 ALTER COLUMN TCS1Code NVARCHAR (10) NOT NULL 
GO

ALTER TABLE VS4TCustom1 WITH NOCHECK ADD 
CONSTRAINT TCS1Type PRIMARY KEY CLUSTERED 
(
TCS1Type,TCS1Code
) ON [PRIMARY]
GO

ALTER TABLE VS4TDebitNoteType ALTER COLUMN TDBTCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TDebitNoteType WITH NOCHECK ADD 
CONSTRAINT TDBTCode PRIMARY KEY CLUSTERED 
(
TDBTCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TDecisionStyle ALTER COLUMN TDecCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TDecisionStyle WITH NOCHECK ADD 
CONSTRAINT TDecCode PRIMARY KEY CLUSTERED 
(
TDecCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TDeliveryIN ALTER COLUMN TDCINo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TDeliveryIN WITH NOCHECK ADD 
CONSTRAINT TDCINo PRIMARY KEY CLUSTERED 
(
TDCINo
) ON [PRIMARY]
GO

ALTER TABLE VS4TDeliveryINMB ALTER COLUMN TDIMLn INT NOT NULL 
GO

ALTER TABLE VS4TDeliveryINMB ALTER COLUMN TDIMTDCINo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TDeliveryINMB WITH NOCHECK ADD 
CONSTRAINT TDIMLn PRIMARY KEY CLUSTERED 
(
TDIMLn,TDIMTDCINo
) ON [PRIMARY]
GO

ALTER TABLE VS4TDeliveryOut ALTER COLUMN TDCONo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TDeliveryOut WITH NOCHECK ADD 
CONSTRAINT TDCONo PRIMARY KEY CLUSTERED 
(
TDCONo
) ON [PRIMARY]
GO

ALTER TABLE VS4TDeliveryOutMB ALTER COLUMN TDOMLn INT NOT NULL 
GO

ALTER TABLE VS4TDeliveryOutMB ALTER COLUMN TDOMTDCONo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TDeliveryOutMB WITH NOCHECK ADD 
CONSTRAINT TDOMLn PRIMARY KEY CLUSTERED 
(
TDOMLn,TDOMTDCONo
) ON [PRIMARY]
GO

ALTER TABLE VS4TDepartment ALTER COLUMN TDepCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TDepartment WITH NOCHECK ADD 
CONSTRAINT TDepCode PRIMARY KEY CLUSTERED 
(
TDepCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TDepositChq ALTER COLUMN TCDCTDPMTDPSNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TDepositChq ALTER COLUMN TCDCTDPMLn INT NOT NULL 
GO

ALTER TABLE VS4TDepositChq WITH NOCHECK ADD 
CONSTRAINT TCDCTDPMTDPSNo PRIMARY KEY CLUSTERED 
(
TCDCTDPMTDPSNo,TCDCTDPMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TDepositChqSub ALTER COLUMN TCDQTDPMTDPSNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TDepositChqSub ALTER COLUMN TCDQTDPMLn INT NOT NULL 
GO

ALTER TABLE VS4TDepositChqSub WITH NOCHECK ADD 
CONSTRAINT TCDQTDPMTDPSNo PRIMARY KEY CLUSTERED 
(
TCDQTDPMTDPSNo,TCDQTDPMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TDistrict ALTER COLUMN TSPVCode NVARCHAR (4) NOT NULL 
GO

ALTER TABLE VS4TDistrict WITH NOCHECK ADD 
CONSTRAINT TSPVCode PRIMARY KEY CLUSTERED 
(
TSPVCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TDivision ALTER COLUMN TDivCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TDivision WITH NOCHECK ADD 
CONSTRAINT TDivCode PRIMARY KEY CLUSTERED 
(
TDivCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TDO ALTER COLUMN TPdyNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TDO WITH NOCHECK ADD 
CONSTRAINT TPdyNo PRIMARY KEY CLUSTERED 
(
TPdyNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TDOBoxSet ALTER COLUMN TDBSNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TDOBoxSet WITH NOCHECK ADD 
CONSTRAINT TDBSNo PRIMARY KEY CLUSTERED 
(
TDBSNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TDOBoxSetMB ALTER COLUMN TDSMTDBSNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TDOBoxSetMB ALTER COLUMN TDSMLn INT NOT NULL 
GO

ALTER TABLE VS4TDOBoxSetMB WITH NOCHECK ADD 
CONSTRAINT TDSMTDBSNo PRIMARY KEY CLUSTERED 
(
TDSMTDBSNo,TDSMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TDOBoxSetNo ALTER COLUMN TDSNTDBSNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TDOBoxSetNo ALTER COLUMN TDSNLn INT NOT NULL 
GO

ALTER TABLE VS4TDOBoxSetNo WITH NOCHECK ADD 
CONSTRAINT TDSNTDBSNo PRIMARY KEY CLUSTERED 
(
TDSNTDBSNo,TDSNLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TDocumentStatus ALTER COLUMN TDStCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TDocumentStatus WITH NOCHECK ADD 
CONSTRAINT TDStCode PRIMARY KEY CLUSTERED 
(
TDStCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TDOMB ALTER COLUMN TDymLn INT NOT NULL 
GO

ALTER TABLE VS4TDOMB ALTER COLUMN TDymTPdyNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TDOMB WITH NOCHECK ADD 
CONSTRAINT TDymLn PRIMARY KEY CLUSTERED 
(
TDymLn,TDymTPdyNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TDOMBDetail ALTER COLUMN TDMDTIoMTIvoNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TDOMBDetail ALTER COLUMN TDMDTIoMLn INT NOT NULL 
GO

ALTER TABLE VS4TDOMBDetail WITH NOCHECK ADD 
CONSTRAINT TDMDTIoMTIvoNo PRIMARY KEY CLUSTERED 
(
TDMDTIoMTIvoNo,TDMDTIoMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TDrawing ALTER COLUMN TDwgCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TDrawing WITH NOCHECK ADD 
CONSTRAINT TDwgCode PRIMARY KEY CLUSTERED 
(
TDwgCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TDrawingImage ALTER COLUMN TDImTDwgCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TDrawingImage ALTER COLUMN TDImCode INT NOT NULL 
GO

ALTER TABLE VS4TDrawingImage WITH NOCHECK ADD 
CONSTRAINT TDImTDwgCode PRIMARY KEY CLUSTERED 
(
TDImTDwgCode,TDImCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TDrawingMB ALTER COLUMN TDwMTDwgCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TDrawingMB ALTER COLUMN TDwMTPdtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TDrawingMB WITH NOCHECK ADD 
CONSTRAINT TDwMTDwgCode PRIMARY KEY CLUSTERED 
(
TDwMTDwgCode,TDwMTPdtCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TEducation ALTER COLUMN TEduCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEducation WITH NOCHECK ADD 
CONSTRAINT TEduCode PRIMARY KEY CLUSTERED 
(
TEduCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpActiveAmass ALTER COLUMN TEAATSAPTEmTCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpActiveAmass ALTER COLUMN TEAATSaPDate DATETIME NOT NULL 
GO

ALTER TABLE VS4TEmpActiveAmass ALTER COLUMN TEAATEmpCode NVARCHAR (50) NOT NULL 
GO

ALTER TABLE VS4TEmpActiveAmass WITH NOCHECK ADD 
CONSTRAINT TEAATSAPTEmTCode PRIMARY KEY CLUSTERED 
(
TEAATSAPTEmTCode,TEAATSaPDate,TEAATEmpCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpAddMoney ALTER COLUMN TAmyCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpAddMoney WITH NOCHECK ADD 
CONSTRAINT TAmyCode PRIMARY KEY CLUSTERED 
(
TAmyCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpAddMoneyTY ALTER COLUMN TAMTAlias NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpAddMoneyTY WITH NOCHECK ADD 
CONSTRAINT TAMTAlias PRIMARY KEY CLUSTERED 
(
TAMTAlias
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpAmassType ALTER COLUMN TEATTEmpCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpAmassType ALTER COLUMN TEATCheckGroup SMALLINT NOT NULL 
GO

ALTER TABLE VS4TEmpAmassType ALTER COLUMN TEATTEmTCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpAmassType ALTER COLUMN TEATPaymentDate DATETIME NOT NULL 
GO

ALTER TABLE VS4TEmpAmassType ALTER COLUMN TEATBalanceFlag SMALLINT NOT NULL 
GO

ALTER TABLE VS4TEmpAmassType WITH NOCHECK ADD 
CONSTRAINT TEATTEmpCode PRIMARY KEY CLUSTERED 
(
TEATTEmpCode,TEATCheckGroup,TEATTEmTCode,TEATPaymentDate,TEATBalanceFlag
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpBuddy ALTER COLUMN TEBuTEmpCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpBuddy ALTER COLUMN TEBuLn INT NOT NULL 
GO

ALTER TABLE VS4TEmpBuddy WITH NOCHECK ADD 
CONSTRAINT TEBuTEmpCode PRIMARY KEY CLUSTERED 
(
TEBuTEmpCode,TEBuLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpChild ALTER COLUMN TEcdLn INT NOT NULL 
GO

ALTER TABLE VS4TEmpChild ALTER COLUMN TEcdTEmpCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpChild WITH NOCHECK ADD 
CONSTRAINT TEcdLn PRIMARY KEY CLUSTERED 
(
TEcdLn,TEcdTEmpCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpCollateFund ALTER COLUMN TEcFLn INT NOT NULL 
GO

ALTER TABLE VS4TEmpCollateFund ALTER COLUMN TEcFTEmpCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpCollateFund WITH NOCHECK ADD 
CONSTRAINT TEcFLn PRIMARY KEY CLUSTERED 
(
TEcFLn,TEcFTEmpCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpCollateral ALTER COLUMN TEclLn INT NOT NULL 
GO

ALTER TABLE VS4TEmpCollateral ALTER COLUMN TEclTEmpCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpCollateral WITH NOCHECK ADD 
CONSTRAINT TEclLn PRIMARY KEY CLUSTERED 
(
TEclLn,TEclTEmpCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpContact ALTER COLUMN TCttLn INT NOT NULL 
GO

ALTER TABLE VS4TEmpContact ALTER COLUMN TCttTEmpCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpContact WITH NOCHECK ADD 
CONSTRAINT TCttLn PRIMARY KEY CLUSTERED 
(
TCttLn,TCttTEmpCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpGroupDoc ALTER COLUMN TEgdNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpGroupDoc WITH NOCHECK ADD 
CONSTRAINT TEgdNo PRIMARY KEY CLUSTERED 
(
TEgdNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpHisEdu ALTER COLUMN THedLn INT NOT NULL 
GO

ALTER TABLE VS4TEmpHisEdu ALTER COLUMN THedTEmpCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpHisEdu WITH NOCHECK ADD 
CONSTRAINT THedLn PRIMARY KEY CLUSTERED 
(
THedLn,THedTEmpCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpHisPosition ALTER COLUMN TEHPTEmpCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpHisPosition ALTER COLUMN TEHPLn INT NOT NULL 
GO

ALTER TABLE VS4TEmpHisPosition ALTER COLUMN TEHPStartDate DATETIME NOT NULL 
GO

ALTER TABLE VS4TEmpHisPosition WITH NOCHECK ADD 
CONSTRAINT TEHPTEmpCode PRIMARY KEY CLUSTERED 
(
TEHPTEmpCode,TEHPLn,TEHPStartDate
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpHisProduce ALTER COLUMN TEHSTEmpCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpHisProduce ALTER COLUMN TEHSLn INT NOT NULL 
GO

ALTER TABLE VS4TEmpHisProduce WITH NOCHECK ADD 
CONSTRAINT TEHSTEmpCode PRIMARY KEY CLUSTERED 
(
TEHSTEmpCode,TEHSLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpHisPunish ALTER COLUMN TEHUTEmpCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpHisPunish ALTER COLUMN TEHULn INT NOT NULL 
GO

ALTER TABLE VS4TEmpHisPunish WITH NOCHECK ADD 
CONSTRAINT TEHUTEmpCode PRIMARY KEY CLUSTERED 
(
TEHUTEmpCode,TEHULn
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpHisWork ALTER COLUMN THwkLn INT NOT NULL 
GO

ALTER TABLE VS4TEmpHisWork ALTER COLUMN THwkTEmpCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpHisWork WITH NOCHECK ADD 
CONSTRAINT THwkLn PRIMARY KEY CLUSTERED 
(
THwkLn,THwkTEmpCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpHoliday ALTER COLUMN TEhdTBraCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpHoliday ALTER COLUMN TEhdHolidayDate DATETIME NOT NULL 
GO

ALTER TABLE VS4TEmpHoliday WITH NOCHECK ADD 
CONSTRAINT TEhdTBraCode PRIMARY KEY CLUSTERED 
(
TEhdTBraCode,TEhdHolidayDate
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpIdentify ALTER COLUMN TIDETEmpCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpIdentify ALTER COLUMN TIDELn INT NOT NULL 
GO

ALTER TABLE VS4TEmpIdentify WITH NOCHECK ADD 
CONSTRAINT TIDETEmpCode PRIMARY KEY CLUSTERED 
(
TIDETEmpCode,TIDELn
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpIncomeDoc ALTER COLUMN TEidNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpIncomeDoc WITH NOCHECK ADD 
CONSTRAINT TEidNo PRIMARY KEY CLUSTERED 
(
TEidNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpIncomeMB ALTER COLUMN TEwoTEidNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpIncomeMB ALTER COLUMN TEwoLn INT NOT NULL 
GO

ALTER TABLE VS4TEmpIncomeMB WITH NOCHECK ADD 
CONSTRAINT TEwoTEidNo PRIMARY KEY CLUSTERED 
(
TEwoTEidNo,TEwoLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpInOutNote ALTER COLUMN TEIOTEmpCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpInOutNote ALTER COLUMN TEIODate DATETIME NOT NULL 
GO

ALTER TABLE VS4TEmpInOutNote ALTER COLUMN TEIOLn INT NOT NULL 
GO

ALTER TABLE VS4TEmpInOutNote WITH NOCHECK ADD 
CONSTRAINT TEIOTEmpCode PRIMARY KEY CLUSTERED 
(
TEIOTEmpCode,TEIODate,TEIOLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpLeave ALTER COLUMN TEpaNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpLeave WITH NOCHECK ADD 
CONSTRAINT TEpaNo PRIMARY KEY CLUSTERED 
(
TEpaNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpLeaveAllow ALTER COLUMN TELATEmpCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpLeaveAllow ALTER COLUMN TELAYear INT NOT NULL 
GO

ALTER TABLE VS4TEmpLeaveAllow ALTER COLUMN TELAType INT NOT NULL 
GO

ALTER TABLE VS4TEmpLeaveAllow WITH NOCHECK ADD 
CONSTRAINT TELATEmpCode PRIMARY KEY CLUSTERED 
(
TELATEmpCode,TELAYear,TELAType
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpLeaveMB ALTER COLUMN TElbLn INT NOT NULL 
GO

ALTER TABLE VS4TEmpLeaveMB ALTER COLUMN TElbTEpaNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpLeaveMB WITH NOCHECK ADD 
CONSTRAINT TElbLn PRIMARY KEY CLUSTERED 
(
TElbLn,TElbTEpaNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpLeaveType ALTER COLUMN TLvtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpLeaveType WITH NOCHECK ADD 
CONSTRAINT TLvtCode PRIMARY KEY CLUSTERED 
(
TLvtCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmployee ALTER COLUMN TEmpCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmployee WITH NOCHECK ADD 
CONSTRAINT TEmpCode PRIMARY KEY CLUSTERED 
(
TEmpCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmployee2 ALTER COLUMN TEm2TEmpCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmployee2 ALTER COLUMN TEm2Ln INT NOT NULL 
GO

ALTER TABLE VS4TEmployee2 WITH NOCHECK ADD 
CONSTRAINT TEm2TEmpCode PRIMARY KEY CLUSTERED 
(
TEm2TEmpCode,TEm2Ln
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmployeeBank ALTER COLUMN TEmBTEmpCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmployeeBank ALTER COLUMN TEmBLn INT NOT NULL 
GO

ALTER TABLE VS4TEmployeeBank WITH NOCHECK ADD 
CONSTRAINT TEmBTEmpCode PRIMARY KEY CLUSTERED 
(
TEmBTEmpCode,TEmBLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmployeeGroup ALTER COLUMN TEmGCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmployeeGroup WITH NOCHECK ADD 
CONSTRAINT TEmGCode PRIMARY KEY CLUSTERED 
(
TEmGCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmployeeGrpMB ALTER COLUMN TEGMTEgdNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmployeeGrpMB ALTER COLUMN TEGMLn INT NOT NULL 
GO

ALTER TABLE VS4TEmployeeGrpMB WITH NOCHECK ADD 
CONSTRAINT TEGMTEgdNo PRIMARY KEY CLUSTERED 
(
TEGMTEgdNo,TEGMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmployeeSub ALTER COLUMN TEMSTEmpCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmployeeSub ALTER COLUMN TEMSLn INT NOT NULL 
GO

ALTER TABLE VS4TEmployeeSub WITH NOCHECK ADD 
CONSTRAINT TEMSTEmpCode PRIMARY KEY CLUSTERED 
(
TEMSTEmpCode,TEMSLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmployeeType ALTER COLUMN TEmTCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmployeeType WITH NOCHECK ADD 
CONSTRAINT TEmTCode PRIMARY KEY CLUSTERED 
(
TEmTCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmployeeTypeSL ALTER COLUMN TGSlTEmTCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmployeeTypeSL ALTER COLUMN TGSlTAmyCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmployeeTypeSL WITH NOCHECK ADD 
CONSTRAINT TGSlTEmTCode PRIMARY KEY CLUSTERED 
(
TGSlTEmTCode,TGSlTAmyCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpOT ALTER COLUMN TEOTNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpOT WITH NOCHECK ADD 
CONSTRAINT TEOTNo PRIMARY KEY CLUSTERED 
(
TEOTNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpOTMB ALTER COLUMN TOTMTEOTNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpOTMB ALTER COLUMN TOTMLn INT NOT NULL 
GO

ALTER TABLE VS4TEmpOTMB WITH NOCHECK ADD 
CONSTRAINT TOTMTEOTNo PRIMARY KEY CLUSTERED 
(
TOTMTEOTNo,TOTMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpParent ALTER COLUMN TEpPTEmpCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpParent ALTER COLUMN TEpPLn INT NOT NULL 
GO

ALTER TABLE VS4TEmpParent WITH NOCHECK ADD 
CONSTRAINT TEpPTEmpCode PRIMARY KEY CLUSTERED 
(
TEpPTEmpCode,TEpPLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpPunish ALTER COLUMN TEPNCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpPunish WITH NOCHECK ADD 
CONSTRAINT TEPNCode PRIMARY KEY CLUSTERED 
(
TEPNCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpRevenue91 ALTER COLUMN TER9TEmpCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpRevenue91 ALTER COLUMN TER9Year SMALLINT NOT NULL 
GO

ALTER TABLE VS4TEmpRevenue91 WITH NOCHECK ADD 
CONSTRAINT TER9TEmpCode PRIMARY KEY CLUSTERED 
(
TER9TEmpCode,TER9Year
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpSalary ALTER COLUMN TSalLn INT NOT NULL 
GO

ALTER TABLE VS4TEmpSalary ALTER COLUMN TSalTEmpCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpSalary WITH NOCHECK ADD 
CONSTRAINT TSalLn PRIMARY KEY CLUSTERED 
(
TSalLn,TSalTEmpCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpSlipDoc ALTER COLUMN TEpsNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpSlipDoc ALTER COLUMN TEpsCheckGroup INT NOT NULL 
GO

ALTER TABLE VS4TEmpSlipDoc WITH NOCHECK ADD 
CONSTRAINT TEpsNo PRIMARY KEY CLUSTERED 
(
TEpsNo,TEpsCheckGroup
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpSlipMB ALTER COLUMN TSmbTEpsNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpSlipMB ALTER COLUMN TSmbTEpsCheckGroup INT NOT NULL 
GO

ALTER TABLE VS4TEmpSlipMB ALTER COLUMN TSmbLn INT NOT NULL 
GO

ALTER TABLE VS4TEmpSlipMB WITH NOCHECK ADD 
CONSTRAINT TSmbTEpsNo PRIMARY KEY CLUSTERED 
(
TSmbTEpsNo,TSmbTEpsCheckGroup,TSmbLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpSlipPeriod ALTER COLUMN TSaPTEmTCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpSlipPeriod ALTER COLUMN TSaPDate DATETIME NOT NULL 
GO

ALTER TABLE VS4TEmpSlipPeriod WITH NOCHECK ADD 
CONSTRAINT TSaPTEmTCode PRIMARY KEY CLUSTERED 
(
TSaPTEmTCode,TSaPDate
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpSpecial ALTER COLUMN TSplLn INT NOT NULL 
GO

ALTER TABLE VS4TEmpSpecial ALTER COLUMN TSplTEmpCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpSpecial WITH NOCHECK ADD 
CONSTRAINT TSplLn PRIMARY KEY CLUSTERED 
(
TSplLn,TSplTEmpCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpTimeChk ALTER COLUMN TEtcNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpTimeChk WITH NOCHECK ADD 
CONSTRAINT TEtcNo PRIMARY KEY CLUSTERED 
(
TEtcNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpTimeChkMB ALTER COLUMN TTCKLn INT NOT NULL 
GO

ALTER TABLE VS4TEmpTimeChkMB ALTER COLUMN TTCKTEtcNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpTimeChkMB WITH NOCHECK ADD 
CONSTRAINT TTCKLn PRIMARY KEY CLUSTERED 
(
TTCKLn,TTCKTEtcNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpTimeFill ALTER COLUMN TTGMTEmpCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpTimeFill ALTER COLUMN TTGMWorkDate DATETIME NOT NULL 
GO

ALTER TABLE VS4TEmpTimeFill WITH NOCHECK ADD 
CONSTRAINT TTGMTEmpCode PRIMARY KEY CLUSTERED 
(
TTGMTEmpCode,TTGMWorkDate
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpTip ALTER COLUMN TETPCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpTip WITH NOCHECK ADD 
CONSTRAINT TETPCode PRIMARY KEY CLUSTERED 
(
TETPCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpTipRate ALTER COLUMN TETRTEmTCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpTipRate ALTER COLUMN TETRFromBase INT NOT NULL 
GO

ALTER TABLE VS4TEmpTipRate WITH NOCHECK ADD 
CONSTRAINT TETRTEmTCode PRIMARY KEY CLUSTERED 
(
TETRTEmTCode,TETRFromBase
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpTraining ALTER COLUMN TETrNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpTraining WITH NOCHECK ADD 
CONSTRAINT TETrNo PRIMARY KEY CLUSTERED 
(
TETrNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpTrainingMB ALTER COLUMN TETmTETrNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpTrainingMB ALTER COLUMN TETmLn INT NOT NULL 
GO

ALTER TABLE VS4TEmpTrainingMB WITH NOCHECK ADD 
CONSTRAINT TETmTETrNo PRIMARY KEY CLUSTERED 
(
TETmTETrNo,TETmLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpUpSalary ALTER COLUMN TEUSNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpUpSalary WITH NOCHECK ADD 
CONSTRAINT TEUSNo PRIMARY KEY CLUSTERED 
(
TEUSNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpUpSalaryMB ALTER COLUMN TEUMTEUSNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpUpSalaryMB ALTER COLUMN TEUMLn INT NOT NULL 
GO

ALTER TABLE VS4TEmpUpSalaryMB WITH NOCHECK ADD 
CONSTRAINT TEUMTEUSNo PRIMARY KEY CLUSTERED 
(
TEUMTEUSNo,TEUMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpWelfare ALTER COLUMN TEWlNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpWelfare WITH NOCHECK ADD 
CONSTRAINT TEWlNo PRIMARY KEY CLUSTERED 
(
TEWlNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpWelfareMB ALTER COLUMN TEWMTEWlNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpWelfareMB ALTER COLUMN TEWMLn INT NOT NULL 
GO

ALTER TABLE VS4TEmpWelfareMB WITH NOCHECK ADD 
CONSTRAINT TEWMTEWlNo PRIMARY KEY CLUSTERED 
(
TEWMTEWlNo,TEWMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpWorkCount ALTER COLUMN TEWCNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpWorkCount WITH NOCHECK ADD 
CONSTRAINT TEWCNo PRIMARY KEY CLUSTERED 
(
TEWCNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpWorkCountMB ALTER COLUMN TECMLn INT NOT NULL 
GO

ALTER TABLE VS4TEmpWorkCountMB ALTER COLUMN TECMTEWCNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpWorkCountMB WITH NOCHECK ADD 
CONSTRAINT TECMLn PRIMARY KEY CLUSTERED 
(
TECMLn,TECMTEWCNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpWorkPeriod ALTER COLUMN TWPDCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpWorkPeriod WITH NOCHECK ADD 
CONSTRAINT TWPDCode PRIMARY KEY CLUSTERED 
(
TWPDCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpWorkRate ALTER COLUMN TWRMCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpWorkRate WITH NOCHECK ADD 
CONSTRAINT TWRMCode PRIMARY KEY CLUSTERED 
(
TWRMCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmpWorkTime ALTER COLUMN TWPTTWPDCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmpWorkTime ALTER COLUMN TWPTWeekDay INT NOT NULL 
GO

ALTER TABLE VS4TEmpWorkTime WITH NOCHECK ADD 
CONSTRAINT TWPTTWPDCode PRIMARY KEY CLUSTERED 
(
TWPTTWPDCode,TWPTWeekDay
) ON [PRIMARY]
GO

ALTER TABLE VS4TEmTLeaveAllow ALTER COLUMN TETLTEmTCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TEmTLeaveAllow ALTER COLUMN TETLYear INT NOT NULL 
GO

ALTER TABLE VS4TEmTLeaveAllow ALTER COLUMN TETLType INT NOT NULL 
GO

ALTER TABLE VS4TEmTLeaveAllow WITH NOCHECK ADD 
CONSTRAINT TETLTEmTCode PRIMARY KEY CLUSTERED 
(
TETLTEmTCode,TETLYear,TETLType
) ON [PRIMARY]
GO

ALTER TABLE VS4TExchange ALTER COLUMN TExcNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TExchange WITH NOCHECK ADD 
CONSTRAINT TExcNo PRIMARY KEY CLUSTERED 
(
TExcNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TExchangeRate ALTER COLUMN TExRLn INT NOT NULL 
GO

ALTER TABLE VS4TExchangeRate ALTER COLUMN TExRTExcNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TExchangeRate WITH NOCHECK ADD 
CONSTRAINT TExRLn PRIMARY KEY CLUSTERED 
(
TExRLn,TExRTExcNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TFlight ALTER COLUMN TFliNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TFlight WITH NOCHECK ADD 
CONSTRAINT TFliNo PRIMARY KEY CLUSTERED 
(
TFliNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TFlightEmployee ALTER COLUMN TFlETFliNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TFlightEmployee ALTER COLUMN TFlELn SMALLINT NOT NULL 
GO

ALTER TABLE VS4TFlightEmployee WITH NOCHECK ADD 
CONSTRAINT TFlETFliNo PRIMARY KEY CLUSTERED 
(
TFlETFliNo,TFlELn
) ON [PRIMARY]
GO

ALTER TABLE VS4TFlightGuide ALTER COLUMN TFlGTFliNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TFlightGuide ALTER COLUMN TFlGLn SMALLINT NOT NULL 
GO

ALTER TABLE VS4TFlightGuide WITH NOCHECK ADD 
CONSTRAINT TFlGTFliNo PRIMARY KEY CLUSTERED 
(
TFlGTFliNo,TFlGLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TFlightVehicle ALTER COLUMN TFVhTFliNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TFlightVehicle ALTER COLUMN TFVhLn SMALLINT NOT NULL 
GO

ALTER TABLE VS4TFlightVehicle WITH NOCHECK ADD 
CONSTRAINT TFVhTFliNo PRIMARY KEY CLUSTERED 
(
TFVhTFliNo,TFVhLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TFormula ALTER COLUMN TForCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TFormula WITH NOCHECK ADD 
CONSTRAINT TForCode PRIMARY KEY CLUSTERED 
(
TForCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TFormulaGroup ALTER COLUMN TFoGCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TFormulaGroup WITH NOCHECK ADD 
CONSTRAINT TFoGCode PRIMARY KEY CLUSTERED 
(
TFoGCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TFormulaMap ALTER COLUMN TFmMAlias NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TFormulaMap WITH NOCHECK ADD 
CONSTRAINT TFmMAlias PRIMARY KEY CLUSTERED 
(
TFmMAlias
) ON [PRIMARY]
GO

ALTER TABLE VS4TFormulaPro ALTER COLUMN TFcPTForCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TFormulaPro ALTER COLUMN TFcPCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TFormulaPro WITH NOCHECK ADD 
CONSTRAINT TFcPTForCode PRIMARY KEY CLUSTERED 
(
TFcPTForCode,TFcPCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TFormulaScript ALTER COLUMN TFuSTFcPTForCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TFormulaScript ALTER COLUMN TFuSTFcPCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TFormulaScript ALTER COLUMN TFuSLn INT NOT NULL 
GO

ALTER TABLE VS4TFormulaScript WITH NOCHECK ADD 
CONSTRAINT TFuSTFcPTForCode PRIMARY KEY CLUSTERED 
(
TFuSTFcPTForCode,TFuSTFcPCode,TFuSLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TFormulaSub ALTER COLUMN TFmSID INT NOT NULL 
GO

ALTER TABLE VS4TFormulaSub WITH NOCHECK ADD 
CONSTRAINT TFmSID PRIMARY KEY CLUSTERED 
(
TFmSID
) ON [PRIMARY]
GO

ALTER TABLE VS4TFormulaSubCell ALTER COLUMN TFSCID INT NOT NULL 
GO

ALTER TABLE VS4TFormulaSubCell WITH NOCHECK ADD 
CONSTRAINT TFSCID PRIMARY KEY CLUSTERED 
(
TFSCID
) ON [PRIMARY]
GO

ALTER TABLE VS4TFormulaSystem ALTER COLUMN TFcSTForCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TFormulaSystem ALTER COLUMN TFcSCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TFormulaSystem WITH NOCHECK ADD 
CONSTRAINT TFcSTForCode PRIMARY KEY CLUSTERED 
(
TFcSTForCode,TFcSCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TFormulaUser ALTER COLUMN TFuUTForCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TFormulaUser ALTER COLUMN TFuUCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TFormulaUser WITH NOCHECK ADD 
CONSTRAINT TFuUTForCode PRIMARY KEY CLUSTERED 
(
TFuUTForCode,TFuUCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TFR ALTER COLUMN TFRHCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TFR WITH NOCHECK ADD 
CONSTRAINT TFRHCode PRIMARY KEY CLUSTERED 
(
TFRHCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TFRColumn ALTER COLUMN TFRCTFRHCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TFRColumn ALTER COLUMN TFRCLn INT NOT NULL 
GO

ALTER TABLE VS4TFRColumn WITH NOCHECK ADD 
CONSTRAINT TFRCTFRHCode PRIMARY KEY CLUSTERED 
(
TFRCTFRHCode,TFRCLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TFreeCode ALTER COLUMN TFreCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TFreeCode WITH NOCHECK ADD 
CONSTRAINT TFreCode PRIMARY KEY CLUSTERED 
(
TFreCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TFRRow ALTER COLUMN TFRRTFRHCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TFRRow ALTER COLUMN TFRRLn INT NOT NULL 
GO

ALTER TABLE VS4TFRRow WITH NOCHECK ADD 
CONSTRAINT TFRRTFRHCode PRIMARY KEY CLUSTERED 
(
TFRRTFRHCode,TFRRLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TFuel ALTER COLUMN TFueDate DATETIME NOT NULL 
GO

ALTER TABLE VS4TFuel WITH NOCHECK ADD 
CONSTRAINT TFueDate PRIMARY KEY CLUSTERED 
(
TFueDate
) ON [PRIMARY]
GO

ALTER TABLE VS4TFund ALTER COLUMN TFunAlias NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TFund WITH NOCHECK ADD 
CONSTRAINT TFunAlias PRIMARY KEY CLUSTERED 
(
TFunAlias
) ON [PRIMARY]
GO

ALTER TABLE VS4TFundRate ALTER COLUMN TFuRTFunAlias NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TFundRate ALTER COLUMN TFuRFromBase FLOAT NOT NULL 
GO

ALTER TABLE VS4TFundRate WITH NOCHECK ADD 
CONSTRAINT TFuRTFunAlias PRIMARY KEY CLUSTERED 
(
TFuRTFunAlias,TFuRFromBase
) ON [PRIMARY]
GO

ALTER TABLE VS4TGLBook ALTER COLUMN TGLBCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TGLBook WITH NOCHECK ADD 
CONSTRAINT TGLBCode PRIMARY KEY CLUSTERED 
(
TGLBCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TGLTrans ALTER COLUMN TGLTNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TGLTrans WITH NOCHECK ADD 
CONSTRAINT TGLTNo PRIMARY KEY CLUSTERED 
(
TGLTNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TGLTransMove ALTER COLUMN TGTMTACPTACYID INT NOT NULL 
GO

ALTER TABLE VS4TGLTransMove ALTER COLUMN TGTMTACPID INT NOT NULL 
GO

ALTER TABLE VS4TGLTransMove ALTER COLUMN TGTMTACCCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TGLTransMove ALTER COLUMN TGTMStatus INT NOT NULL 
GO

ALTER TABLE VS4TGLTransMove ALTER COLUMN TGTMMode INT NOT NULL 
GO

ALTER TABLE VS4TGLTransMove ALTER COLUMN TGTMTBraCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TGLTransMove WITH NOCHECK ADD 
CONSTRAINT TGTMTACPTACYID PRIMARY KEY CLUSTERED 
(
TGTMTACPTACYID,TGTMTACPID,TGTMTACCCode,TGTMStatus,TGTMMode,TGTMTBraCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TGLTransSub ALTER COLUMN TGTSTGLTNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TGLTransSub ALTER COLUMN TGTSLn INT NOT NULL 
GO

ALTER TABLE VS4TGLTransSub WITH NOCHECK ADD 
CONSTRAINT TGTSTGLTNo PRIMARY KEY CLUSTERED 
(
TGTSTGLTNo,TGTSLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TGovPayment ALTER COLUMN TGvPMonth INT NOT NULL 
GO

ALTER TABLE VS4TGovPayment ALTER COLUMN TGvPYear INT NOT NULL 
GO

ALTER TABLE VS4TGovPayment ALTER COLUMN TGvPType INT NOT NULL 
GO

ALTER TABLE VS4TGovPayment WITH NOCHECK ADD 
CONSTRAINT TGvPMonth PRIMARY KEY CLUSTERED 
(
TGvPMonth,TGvPYear,TGvPType
) ON [PRIMARY]
GO

ALTER TABLE VS4TGovPaymentMB ALTER COLUMN TGvMTGvPMonth INT NOT NULL 
GO

ALTER TABLE VS4TGovPaymentMB ALTER COLUMN TGvMTGvPYear INT NOT NULL 
GO

ALTER TABLE VS4TGovPaymentMB ALTER COLUMN TGvMTGvPType INT NOT NULL 
GO

ALTER TABLE VS4TGovPaymentMB ALTER COLUMN TGvMLn INT NOT NULL 
GO

ALTER TABLE VS4TGovPaymentMB WITH NOCHECK ADD 
CONSTRAINT TGvMTGvPMonth PRIMARY KEY CLUSTERED 
(
TGvMTGvPMonth,TGvMTGvPYear,TGvMTGvPType,TGvMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TGroup ALTER COLUMN TGroID INT NOT NULL 
GO

ALTER TABLE VS4TGroup WITH NOCHECK ADD 
CONSTRAINT TGroID PRIMARY KEY CLUSTERED 
(
TGroID
) ON [PRIMARY]
GO

ALTER TABLE VS4TGroupMB ALTER COLUMN TGrMTUsrID INT NOT NULL 
GO

ALTER TABLE VS4TGroupMB ALTER COLUMN TGrMTGroID INT NOT NULL 
GO

ALTER TABLE VS4TGroupMB WITH NOCHECK ADD 
CONSTRAINT TGrMTUsrID PRIMARY KEY CLUSTERED 
(
TGrMTUsrID,TGrMTGroID
) ON [PRIMARY]
GO

ALTER TABLE VS4TGroupPermiss ALTER COLUMN TGrPTCmdID INT NOT NULL 
GO

ALTER TABLE VS4TGroupPermiss ALTER COLUMN TGrPTGroID INT NOT NULL 
GO

ALTER TABLE VS4TGroupPermiss WITH NOCHECK ADD 
CONSTRAINT TGrPTCmdID PRIMARY KEY CLUSTERED 
(
TGrPTCmdID,TGrPTGroID
) ON [PRIMARY]
GO

ALTER TABLE VS4THoliday ALTER COLUMN THysID INT NOT NULL 
GO

ALTER TABLE VS4THoliday WITH NOCHECK ADD 
CONSTRAINT THysID PRIMARY KEY CLUSTERED 
(
THysID
) ON [PRIMARY]
GO

ALTER TABLE VS4THostProfile ALTER COLUMN THPfCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4THostProfile WITH NOCHECK ADD 
CONSTRAINT THPfCode PRIMARY KEY CLUSTERED 
(
THPfCode
) ON [PRIMARY]
GO

ALTER TABLE VS4THostProfileGrp ALTER COLUMN THPGALIAS NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4THostProfileGrp WITH NOCHECK ADD 
CONSTRAINT THPGALIAS PRIMARY KEY CLUSTERED 
(
THPGALIAS
) ON [PRIMARY]
GO

ALTER TABLE VS4THostProfileMB ALTER COLUMN THPMID INT NOT NULL 
GO

ALTER TABLE VS4THostProfileMB WITH NOCHECK ADD 
CONSTRAINT THPMID PRIMARY KEY CLUSTERED 
(
THPMID
) ON [PRIMARY]
GO

ALTER TABLE VS4TImportantDay ALTER COLUMN TImDCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TImportantDay WITH NOCHECK ADD 
CONSTRAINT TImDCode PRIMARY KEY CLUSTERED 
(
TImDCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TInCorp ALTER COLUMN TIncCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInCorp WITH NOCHECK ADD 
CONSTRAINT TIncCode PRIMARY KEY CLUSTERED 
(
TIncCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TInCorpMB ALTER COLUMN TICMTCmpCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInCorpMB ALTER COLUMN TICMTIncCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInCorpMB WITH NOCHECK ADD 
CONSTRAINT TICMTCmpCode PRIMARY KEY CLUSTERED 
(
TICMTCmpCode,TICMTIncCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TInquiry ALTER COLUMN TIQRCode NVARCHAR (15) NOT NULL 
GO

ALTER TABLE VS4TInquiry WITH NOCHECK ADD 
CONSTRAINT TIQRCode PRIMARY KEY CLUSTERED 
(
TIQRCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TInquiryChoice ALTER COLUMN TIQCTIQRCode NVARCHAR (15) NOT NULL 
GO

ALTER TABLE VS4TInquiryChoice ALTER COLUMN TIQCLn INT NOT NULL 
GO

ALTER TABLE VS4TInquiryChoice WITH NOCHECK ADD 
CONSTRAINT TIQCTIQRCode PRIMARY KEY CLUSTERED 
(
TIQCTIQRCode,TIQCLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TInquiryGroup ALTER COLUMN TIQGCode NVARCHAR (15) NOT NULL 
GO

ALTER TABLE VS4TInquiryGroup WITH NOCHECK ADD 
CONSTRAINT TIQGCode PRIMARY KEY CLUSTERED 
(
TIQGCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TInsurance ALTER COLUMN TIslNo NVARCHAR (50) NOT NULL 
GO

ALTER TABLE VS4TInsurance WITH NOCHECK ADD 
CONSTRAINT TIslNo PRIMARY KEY CLUSTERED 
(
TIslNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TInsuranceType ALTER COLUMN TIsTCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInsuranceType WITH NOCHECK ADD 
CONSTRAINT TIsTCode PRIMARY KEY CLUSTERED 
(
TIsTCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TInterCode ALTER COLUMN TItCCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInterCode WITH NOCHECK ADD 
CONSTRAINT TItCCode PRIMARY KEY CLUSTERED 
(
TItCCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TInventAdjust ALTER COLUMN TIjtNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventAdjust WITH NOCHECK ADD 
CONSTRAINT TIjtNo PRIMARY KEY CLUSTERED 
(
TIjtNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TInventAdjustMB ALTER COLUMN TIjMTIjtNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventAdjustMB ALTER COLUMN TIjMLn INT NOT NULL 
GO

ALTER TABLE VS4TInventAdjustMB WITH NOCHECK ADD 
CONSTRAINT TIjMTIjtNo PRIMARY KEY CLUSTERED 
(
TIjMTIjtNo,TIjMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TInventAPCN ALTER COLUMN TIPITInMTInvNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventAPCN ALTER COLUMN TIPITInMLn INT NOT NULL 
GO

ALTER TABLE VS4TInventAPCN ALTER COLUMN TIPITPCMTPCNNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventAPCN ALTER COLUMN TIPITPCMLn INT NOT NULL 
GO

ALTER TABLE VS4TInventAPCN WITH NOCHECK ADD 
CONSTRAINT TIPITInMTInvNo PRIMARY KEY CLUSTERED 
(
TIPITInMTInvNo,TIPITInMLn,TIPITPCMTPCNNo,TIPITPCMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TInventAPIV ALTER COLUMN TIPVTIoMTInvNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventAPIV ALTER COLUMN TIPVTIoMLn INT NOT NULL 
GO

ALTER TABLE VS4TInventAPIV ALTER COLUMN TIPVTIPMTIAPNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventAPIV ALTER COLUMN TIPVTIPMLn INT NOT NULL 
GO

ALTER TABLE VS4TInventAPIV WITH NOCHECK ADD 
CONSTRAINT TIPVTIoMTInvNo PRIMARY KEY CLUSTERED 
(
TIPVTIoMTInvNo,TIPVTIoMLn,TIPVTIPMTIAPNo,TIPVTIPMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TInventARCN ALTER COLUMN TIRCTInMTInvNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventARCN ALTER COLUMN TIRCTInMLn INT NOT NULL 
GO

ALTER TABLE VS4TInventARCN ALTER COLUMN TIRCTRCMTRCNNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventARCN ALTER COLUMN TIRCTRCMLn INT NOT NULL 
GO

ALTER TABLE VS4TInventARCN WITH NOCHECK ADD 
CONSTRAINT TIRCTInMTInvNo PRIMARY KEY CLUSTERED 
(
TIRCTInMTInvNo,TIRCTInMLn,TIRCTRCMTRCNNo,TIRCTRCMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TInventARIV ALTER COLUMN TIRVTInMTInvNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventARIV ALTER COLUMN TIRVTInMLn INT NOT NULL 
GO

ALTER TABLE VS4TInventARIV ALTER COLUMN TIRVTIoMTTvoNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventARIV ALTER COLUMN TIRVTIoMLn INT NOT NULL 
GO

ALTER TABLE VS4TInventARIV WITH NOCHECK ADD 
CONSTRAINT TIRVTInMTInvNo PRIMARY KEY CLUSTERED 
(
TIRVTInMTInvNo,TIRVTInMLn,TIRVTIoMTTvoNo,TIRVTIoMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TInventBook ALTER COLUMN TIBkCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventBook WITH NOCHECK ADD 
CONSTRAINT TIBkCode PRIMARY KEY CLUSTERED 
(
TIBkCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TInventMDS ALTER COLUMN TIDSTInMTInvNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventMDS ALTER COLUMN TIDSTInMLn INT NOT NULL 
GO

ALTER TABLE VS4TInventMDS ALTER COLUMN TIDSTMDSTSOBTSODNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventMDS ALTER COLUMN TIDSTMDSTSOBLn INT NOT NULL 
GO

ALTER TABLE VS4TInventMDS ALTER COLUMN TIDSTMDSLn INT NOT NULL 
GO

ALTER TABLE VS4TInventMDS WITH NOCHECK ADD 
CONSTRAINT TIDSTInMTInvNo PRIMARY KEY CLUSTERED 
(
TIDSTInMTInvNo,TIDSTInMLn,TIDSTMDSTSOBTSODNo,TIDSTMDSTSOBLn,TIDSTMDSLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TInventory ALTER COLUMN TInvNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventory WITH NOCHECK ADD 
CONSTRAINT TInvNo PRIMARY KEY CLUSTERED 
(
TInvNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TInventory2 ALTER COLUMN TIn2TInvNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventory2 ALTER COLUMN TIn2Ln INT NOT NULL 
GO

ALTER TABLE VS4TInventory2 WITH NOCHECK ADD 
CONSTRAINT TIn2TInvNo PRIMARY KEY CLUSTERED 
(
TIn2TInvNo,TIn2Ln
) ON [PRIMARY]
GO

ALTER TABLE VS4TInventory2P ALTER COLUMN TIn2TInvNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventory2P ALTER COLUMN TIn2Ln INT NOT NULL 
GO

ALTER TABLE VS4TInventory2P WITH NOCHECK ADD 
CONSTRAINT TIn2TInvNo PRIMARY KEY CLUSTERED 
(
TIn2TInvNo,TIn2Ln
) ON [PRIMARY]
GO

ALTER TABLE VS4TInventoryCost ALTER COLUMN TIM2Ln INT NOT NULL 
GO

ALTER TABLE VS4TInventoryCost ALTER COLUMN TIM2TPdtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventoryCost ALTER COLUMN TIM2Custom1 NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventoryCost ALTER COLUMN TIM2SerialNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventoryCost ALTER COLUMN TIM2LotNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventoryCost ALTER COLUMN TIM2LotDate DATETIME NOT NULL 
GO

ALTER TABLE VS4TInventoryCost WITH NOCHECK ADD 
CONSTRAINT TIM2Ln PRIMARY KEY CLUSTERED 
(
TIM2Ln,TIM2TPdtCode,TIM2Custom1,TIM2SerialNo,TIM2LotNo,TIM2LotDate
) ON [PRIMARY]
GO

ALTER TABLE VS4TInventoryCostP ALTER COLUMN TIM2Ln INT NOT NULL 
GO

ALTER TABLE VS4TInventoryCostP ALTER COLUMN TIM2TPdtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventoryCostP ALTER COLUMN TIM2Custom1 NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventoryCostP ALTER COLUMN TIM2SerialNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventoryCostP ALTER COLUMN TIM2LotNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventoryCostP ALTER COLUMN TIM2LotDate DATETIME NOT NULL 
GO

ALTER TABLE VS4TInventoryCostP WITH NOCHECK ADD 
CONSTRAINT TIM2Ln PRIMARY KEY CLUSTERED 
(
TIM2Ln,TIM2TPdtCode,TIM2Custom1,TIM2SerialNo,TIM2LotNo,TIM2LotDate
) ON [PRIMARY]
GO

ALTER TABLE VS4TInventoryInit ALTER COLUMN TInIID INT NOT NULL 
GO

ALTER TABLE VS4TInventoryInit WITH NOCHECK ADD 
CONSTRAINT TInIID PRIMARY KEY CLUSTERED 
(
TInIID
) ON [PRIMARY]
GO

ALTER TABLE VS4TInventoryInitG ALTER COLUMN TInGAlias NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventoryInitG WITH NOCHECK ADD 
CONSTRAINT TInGAlias PRIMARY KEY CLUSTERED 
(
TInGAlias
) ON [PRIMARY]
GO

ALTER TABLE VS4TInventoryLOT ALTER COLUMN TIMCTPdtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventoryLOT ALTER COLUMN TIMCCustom1 NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventoryLOT ALTER COLUMN TIMCSerialNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventoryLOT ALTER COLUMN TIMCLotNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventoryLOT ALTER COLUMN TIMCLotDate DATETIME NOT NULL 
GO

ALTER TABLE VS4TInventoryLOT WITH NOCHECK ADD 
CONSTRAINT TIMCTPdtCode PRIMARY KEY CLUSTERED 
(
TIMCTPdtCode,TIMCCustom1,TIMCSerialNo,TIMCLotNo,TIMCLotDate
) ON [PRIMARY]
GO

ALTER TABLE VS4TInventoryLOTP ALTER COLUMN TIMCTPdtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventoryLOTP ALTER COLUMN TIMCCustom1 NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventoryLOTP ALTER COLUMN TIMCSerialNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventoryLOTP ALTER COLUMN TIMCLotNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventoryLOTP ALTER COLUMN TIMCLotDate DATETIME NOT NULL 
GO

ALTER TABLE VS4TInventoryLOTP WITH NOCHECK ADD 
CONSTRAINT TIMCTPdtCode PRIMARY KEY CLUSTERED 
(
TIMCTPdtCode,TIMCCustom1,TIMCSerialNo,TIMCLotNo,TIMCLotDate
) ON [PRIMARY]
GO

ALTER TABLE VS4TInventoryMB ALTER COLUMN TInMTInvNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventoryMB ALTER COLUMN TInMLn INT NOT NULL 
GO

ALTER TABLE VS4TInventoryMB WITH NOCHECK ADD 
CONSTRAINT TInMTInvNo PRIMARY KEY CLUSTERED 
(
TInMTInvNo,TInMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TInventoryMBP ALTER COLUMN TInMTInvNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventoryMBP ALTER COLUMN TInMLn INT NOT NULL 
GO

ALTER TABLE VS4TInventoryMBP WITH NOCHECK ADD 
CONSTRAINT TInMTInvNo PRIMARY KEY CLUSTERED 
(
TInMTInvNo,TInMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TInventoryP ALTER COLUMN TInvNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventoryP WITH NOCHECK ADD 
CONSTRAINT TInvNo PRIMARY KEY CLUSTERED 
(
TInvNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TInventoryType ALTER COLUMN TInTAlias NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventoryType WITH NOCHECK ADD 
CONSTRAINT TInTAlias PRIMARY KEY CLUSTERED 
(
TInTAlias
) ON [PRIMARY]
GO

ALTER TABLE VS4TInventPDE ALTER COLUMN TIDPTInMTInvNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventPDE ALTER COLUMN TIDPTInMLn INT NOT NULL 
GO

ALTER TABLE VS4TInventPDE ALTER COLUMN TIDPTPDETPOBTPODNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventPDE ALTER COLUMN TIDPTPDETPOBLn INT NOT NULL 
GO

ALTER TABLE VS4TInventPDE ALTER COLUMN TIDPTPDELn INT NOT NULL 
GO

ALTER TABLE VS4TInventPDE WITH NOCHECK ADD 
CONSTRAINT TIDPTInMTInvNo PRIMARY KEY CLUSTERED 
(
TIDPTInMTInvNo,TIDPTInMLn,TIDPTPDETPOBTPODNo,TIDPTPDETPOBLn,TIDPTPDELn
) ON [PRIMARY]
GO

ALTER TABLE VS4TInventPeriod ALTER COLUMN TIvPTACPTACYID INT NOT NULL 
GO

ALTER TABLE VS4TInventPeriod ALTER COLUMN TIvPTACPID INT NOT NULL 
GO

ALTER TABLE VS4TInventPeriod ALTER COLUMN TIvPTBraCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventPeriod WITH NOCHECK ADD 
CONSTRAINT TIvPTACPTACYID PRIMARY KEY CLUSTERED 
(
TIvPTACPTACYID,TIvPTACPID,TIvPTBraCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TInventSerial ALTER COLUMN TInRLn NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventSerial ALTER COLUMN TInRTPdtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventSerial ALTER COLUMN TInRCustom1 NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventSerial ALTER COLUMN TInRSerialNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventSerial ALTER COLUMN TInRLotNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TInventSerial ALTER COLUMN TInRLotDate DATETIME NOT NULL 
GO

ALTER TABLE VS4TInventSerial WITH NOCHECK ADD 
CONSTRAINT TInRLn PRIMARY KEY CLUSTERED 
(
TInRLn,TInRTPdtCode,TInRCustom1,TInRSerialNo,TInRLotNo,TInRLotDate
) ON [PRIMARY]
GO

ALTER TABLE VS4TISO ALTER COLUMN TISOCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TISO WITH NOCHECK ADD 
CONSTRAINT TISOCode PRIMARY KEY CLUSTERED 
(
TISOCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TISOGroup ALTER COLUMN TISGCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TISOGroup WITH NOCHECK ADD 
CONSTRAINT TISGCode PRIMARY KEY CLUSTERED 
(
TISGCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TJob ALTER COLUMN TJobNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TJob WITH NOCHECK ADD 
CONSTRAINT TJobNo PRIMARY KEY CLUSTERED 
(
TJobNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TJobBook ALTER COLUMN TJBkCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TJobBook WITH NOCHECK ADD 
CONSTRAINT TJBkCode PRIMARY KEY CLUSTERED 
(
TJBkCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TJobCostSheet ALTER COLUMN TJCSID INT NOT NULL 
GO

ALTER TABLE VS4TJobCostSheet WITH NOCHECK ADD 
CONSTRAINT TJCSID PRIMARY KEY CLUSTERED 
(
TJCSID
) ON [PRIMARY]
GO

ALTER TABLE VS4TJobDL ALTER COLUMN TJDLTJbMTJobNo NVARCHAR (50) NOT NULL 
GO

ALTER TABLE VS4TJobDL ALTER COLUMN TJDLTJbMLn INT NOT NULL 
GO

ALTER TABLE VS4TJobDL ALTER COLUMN TJDLTSpdStep INT NOT NULL 
GO

ALTER TABLE VS4TJobDL ALTER COLUMN TJDLLn INT NOT NULL 
GO

ALTER TABLE VS4TJobDL WITH NOCHECK ADD 
CONSTRAINT TJDLTJbMTJobNo PRIMARY KEY CLUSTERED 
(
TJDLTJbMTJobNo,TJDLTJbMLn,TJDLTSpdStep,TJDLLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TJobHistory ALTER COLUMN TJbHTJobNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TJobHistory ALTER COLUMN TJbHLn INT NOT NULL 
GO

ALTER TABLE VS4TJobHistory WITH NOCHECK ADD 
CONSTRAINT TJbHTJobNo PRIMARY KEY CLUSTERED 
(
TJbHTJobNo,TJbHLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TJobMaterial ALTER COLUMN TJMtTJbMTJobNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TJobMaterial ALTER COLUMN TJMtTJbMLn INT NOT NULL 
GO

ALTER TABLE VS4TJobMaterial ALTER COLUMN TJMtTSpdStep INT NOT NULL 
GO

ALTER TABLE VS4TJobMaterial ALTER COLUMN TJMtLn INT NOT NULL 
GO

ALTER TABLE VS4TJobMaterial WITH NOCHECK ADD 
CONSTRAINT TJMtTJbMTJobNo PRIMARY KEY CLUSTERED 
(
TJMtTJbMTJobNo,TJMtTJbMLn,TJMtTSpdStep,TJMtLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TJobMB ALTER COLUMN TJbMTJobNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TJobMB ALTER COLUMN TJbMLn INT NOT NULL 
GO

ALTER TABLE VS4TJobMB WITH NOCHECK ADD 
CONSTRAINT TJbMTJobNo PRIMARY KEY CLUSTERED 
(
TJbMTJobNo,TJbMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TJobMBSerial ALTER COLUMN TJMSID INT NOT NULL 
GO

ALTER TABLE VS4TJobMBSerial WITH NOCHECK ADD 
CONSTRAINT TJMSID PRIMARY KEY CLUSTERED 
(
TJMSID
) ON [PRIMARY]
GO

ALTER TABLE VS4TJobMethod ALTER COLUMN TJStTJbMTJobNo NVARCHAR (50) NOT NULL 
GO

ALTER TABLE VS4TJobMethod ALTER COLUMN TJStTJbMLn INT NOT NULL 
GO

ALTER TABLE VS4TJobMethod ALTER COLUMN TJStTSpdStep INT NOT NULL 
GO

ALTER TABLE VS4TJobMethod ALTER COLUMN TJStLn INT NOT NULL 
GO

ALTER TABLE VS4TJobMethod WITH NOCHECK ADD 
CONSTRAINT TJStTJbMTJobNo PRIMARY KEY CLUSTERED 
(
TJStTJbMTJobNo,TJStTJbMLn,TJStTSpdStep,TJStLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TJobProdBook ALTER COLUMN TJPkCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TJobProdBook WITH NOCHECK ADD 
CONSTRAINT TJPkCode PRIMARY KEY CLUSTERED 
(
TJPkCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TJobProdDL ALTER COLUMN TJPLTJPdNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TJobProdDL ALTER COLUMN TJPLStep INT NOT NULL 
GO

ALTER TABLE VS4TJobProdDL ALTER COLUMN TJPLLn INT NOT NULL 
GO

ALTER TABLE VS4TJobProdDL WITH NOCHECK ADD 
CONSTRAINT TJPLTJPdNo PRIMARY KEY CLUSTERED 
(
TJPLTJPdNo,TJPLStep,TJPLLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TJobProdExpDoc ALTER COLUMN TJpeNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TJobProdExpDoc WITH NOCHECK ADD 
CONSTRAINT TJpeNo PRIMARY KEY CLUSTERED 
(
TJpeNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TJobProdExpMB ALTER COLUMN TJebTJpeNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TJobProdExpMB ALTER COLUMN TJebLn INT NOT NULL 
GO

ALTER TABLE VS4TJobProdExpMB WITH NOCHECK ADD 
CONSTRAINT TJebTJpeNo PRIMARY KEY CLUSTERED 
(
TJebTJpeNo,TJebLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TJobProdMat ALTER COLUMN TMteTJPdNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TJobProdMat ALTER COLUMN TMteStep INT NOT NULL 
GO

ALTER TABLE VS4TJobProdMat ALTER COLUMN TMteLn INT NOT NULL 
GO

ALTER TABLE VS4TJobProdMat WITH NOCHECK ADD 
CONSTRAINT TMteTJPdNo PRIMARY KEY CLUSTERED 
(
TMteTJPdNo,TMteStep,TMteLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TJobProduction ALTER COLUMN TJPdNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TJobProduction WITH NOCHECK ADD 
CONSTRAINT TJPdNo PRIMARY KEY CLUSTERED 
(
TJPdNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TJobProductionM ALTER COLUMN TJPMTJPdNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TJobProductionM ALTER COLUMN TJPMLn INT NOT NULL 
GO

ALTER TABLE VS4TJobProductionM WITH NOCHECK ADD 
CONSTRAINT TJPMTJPdNo PRIMARY KEY CLUSTERED 
(
TJPMTJPdNo,TJPMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TJobVariance ALTER COLUMN TJVAID INT NOT NULL 
GO

ALTER TABLE VS4TJobVariance WITH NOCHECK ADD 
CONSTRAINT TJVAID PRIMARY KEY CLUSTERED 
(
TJVAID
) ON [PRIMARY]
GO

ALTER TABLE VS4TKBase ALTER COLUMN TKBsNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TKBase ALTER COLUMN TKBsLn INT NOT NULL 
GO

ALTER TABLE VS4TKBase WITH NOCHECK ADD 
CONSTRAINT TKBsNo PRIMARY KEY CLUSTERED 
(
TKBsNo,TKBsLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TKBaseGroup ALTER COLUMN TKBGCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TKBaseGroup WITH NOCHECK ADD 
CONSTRAINT TKBGCode PRIMARY KEY CLUSTERED 
(
TKBGCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TLeaveContact ALTER COLUMN TLCoOffense NVARCHAR (50) NOT NULL 
GO

ALTER TABLE VS4TLeaveContact WITH NOCHECK ADD 
CONSTRAINT TLCoOffense PRIMARY KEY CLUSTERED 
(
TLCoOffense
) ON [PRIMARY]
GO

ALTER TABLE VS4TLocation ALTER COLUMN TLctCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TLocation WITH NOCHECK ADD 
CONSTRAINT TLctCode PRIMARY KEY CLUSTERED 
(
TLctCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TLocationMap ALTER COLUMN TLcMCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TLocationMap WITH NOCHECK ADD 
CONSTRAINT TLcMCode PRIMARY KEY CLUSTERED 
(
TLcMCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TLocationRoom ALTER COLUMN TRomCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TLocationRoom WITH NOCHECK ADD 
CONSTRAINT TRomCode PRIMARY KEY CLUSTERED 
(
TRomCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TMDS ALTER COLUMN TMDNNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TMDS WITH NOCHECK ADD 
CONSTRAINT TMDNNo PRIMARY KEY CLUSTERED 
(
TMDNNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TMDSMB ALTER COLUMN TMDMTMDNNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TMDSMB ALTER COLUMN TMDMLn INT NOT NULL 
GO

ALTER TABLE VS4TMDSMB WITH NOCHECK ADD 
CONSTRAINT TMDMTMDNNo PRIMARY KEY CLUSTERED 
(
TMDMTMDNNo,TMDMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TMedia ALTER COLUMN TMedCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TMedia WITH NOCHECK ADD 
CONSTRAINT TMedCode PRIMARY KEY CLUSTERED 
(
TMedCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TMember ALTER COLUMN TMbrCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TMember WITH NOCHECK ADD 
CONSTRAINT TMbrCode PRIMARY KEY CLUSTERED 
(
TMbrCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TMemberCard ALTER COLUMN TMCDCode NVARCHAR (15) NOT NULL 
GO

ALTER TABLE VS4TMemberCard WITH NOCHECK ADD 
CONSTRAINT TMCDCode PRIMARY KEY CLUSTERED 
(
TMCDCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TMemberGroup ALTER COLUMN TMbGCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TMemberGroup WITH NOCHECK ADD 
CONSTRAINT TMbGCode PRIMARY KEY CLUSTERED 
(
TMbGCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TMemberGroupMB ALTER COLUMN TMMBTMbrCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TMemberGroupMB ALTER COLUMN TMMBTMbGCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TMemberGroupMB WITH NOCHECK ADD 
CONSTRAINT TMMBTMbrCode PRIMARY KEY CLUSTERED 
(
TMMBTMbrCode,TMMBTMbGCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TMessage ALTER COLUMN TMsgID INT NOT NULL 
GO

ALTER TABLE VS4TMessage WITH NOCHECK ADD 
CONSTRAINT TMsgID PRIMARY KEY CLUSTERED 
(
TMsgID
) ON [PRIMARY]
GO

ALTER TABLE VS4TModuleCommand ALTER COLUMN TMdCTCmGAlias NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TModuleCommand ALTER COLUMN TMdCTCmdID INT NOT NULL 
GO

ALTER TABLE VS4TModuleCommand WITH NOCHECK ADD 
CONSTRAINT TMdCTCmGAlias PRIMARY KEY CLUSTERED 
(
TMdCTCmGAlias,TMdCTCmdID
) ON [PRIMARY]
GO

ALTER TABLE VS4TModulePermiss ALTER COLUMN TMdPTCmGAlias NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TModulePermiss ALTER COLUMN TMdPID INT NOT NULL 
GO

ALTER TABLE VS4TModulePermiss ALTER COLUMN TMdPIDType NVARCHAR (1) NOT NULL 
GO

ALTER TABLE VS4TModulePermiss WITH NOCHECK ADD 
CONSTRAINT TMdPTCmGAlias PRIMARY KEY CLUSTERED 
(
TMdPTCmGAlias,TMdPID,TMdPIDType
) ON [PRIMARY]
GO

ALTER TABLE VS4TMold ALTER COLUMN TMolCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TMold WITH NOCHECK ADD 
CONSTRAINT TMolCode PRIMARY KEY CLUSTERED 
(
TMolCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TMoldSet ALTER COLUMN TMoSCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TMoldSet WITH NOCHECK ADD 
CONSTRAINT TMoSCode PRIMARY KEY CLUSTERED 
(
TMoSCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TMoldSetMB ALTER COLUMN TMSMTMoSCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TMoldSetMB ALTER COLUMN TMSMLn INT NOT NULL 
GO

ALTER TABLE VS4TMoldSetMB WITH NOCHECK ADD 
CONSTRAINT TMSMTMoSCode PRIMARY KEY CLUSTERED 
(
TMSMTMoSCode,TMSMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TMoldSetup ALTER COLUMN TMSPTMoSCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TMoldSetup ALTER COLUMN TMSPLn INT NOT NULL 
GO

ALTER TABLE VS4TMoldSetup WITH NOCHECK ADD 
CONSTRAINT TMSPTMoSCode PRIMARY KEY CLUSTERED 
(
TMSPTMoSCode,TMSPLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TMPR ALTER COLUMN TMPRNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TMPR WITH NOCHECK ADD 
CONSTRAINT TMPRNo PRIMARY KEY CLUSTERED 
(
TMPRNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TMPRMB ALTER COLUMN TMPMTMPRNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TMPRMB ALTER COLUMN TMPMLn INT NOT NULL 
GO

ALTER TABLE VS4TMPRMB WITH NOCHECK ADD 
CONSTRAINT TMPMTMPRNo PRIMARY KEY CLUSTERED 
(
TMPMTMPRNo,TMPMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TMPS ALTER COLUMN TMPSNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TMPS WITH NOCHECK ADD 
CONSTRAINT TMPSNo PRIMARY KEY CLUSTERED 
(
TMPSNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TMRPFormula ALTER COLUMN TMRFID INT NOT NULL 
GO

ALTER TABLE VS4TMRPFormula WITH NOCHECK ADD 
CONSTRAINT TMRFID PRIMARY KEY CLUSTERED 
(
TMRFID
) ON [PRIMARY]
GO

ALTER TABLE VS4TMRPFormulaGrp ALTER COLUMN TMRGCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TMRPFormulaGrp WITH NOCHECK ADD 
CONSTRAINT TMRGCode PRIMARY KEY CLUSTERED 
(
TMRGCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TMRPFormulaSet ALTER COLUMN TMRSTMRGCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TMRPFormulaSet ALTER COLUMN TMRSCode NVARCHAR (100) NOT NULL 
GO

ALTER TABLE VS4TMRPFormulaSet WITH NOCHECK ADD 
CONSTRAINT TMRSTMRGCode PRIMARY KEY CLUSTERED 
(
TMRSTMRGCode,TMRSCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TMRPStepName ALTER COLUMN TSepCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TMRPStepName WITH NOCHECK ADD 
CONSTRAINT TSepCode PRIMARY KEY CLUSTERED 
(
TSepCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TNational ALTER COLUMN TNalCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TNational WITH NOCHECK ADD 
CONSTRAINT TNalCode PRIMARY KEY CLUSTERED 
(
TNalCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TNews ALTER COLUMN TNewNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TNews WITH NOCHECK ADD 
CONSTRAINT TNewNo PRIMARY KEY CLUSTERED 
(
TNewNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TOpportunity ALTER COLUMN TOTNTARNCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TOpportunity ALTER COLUMN TOTNLn INT NOT NULL 
GO

ALTER TABLE VS4TOpportunity WITH NOCHECK ADD 
CONSTRAINT TOTNTARNCode PRIMARY KEY CLUSTERED 
(
TOTNTARNCode,TOTNLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TOtherExpense ALTER COLUMN TOExCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TOtherExpense WITH NOCHECK ADD 
CONSTRAINT TOExCode PRIMARY KEY CLUSTERED 
(
TOExCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TOtherIncome ALTER COLUMN TOInCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TOtherIncome WITH NOCHECK ADD 
CONSTRAINT TOInCode PRIMARY KEY CLUSTERED 
(
TOInCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TPA ALTER COLUMN TPADNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPA WITH NOCHECK ADD 
CONSTRAINT TPADNo PRIMARY KEY CLUSTERED 
(
TPADNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TPackingList ALTER COLUMN TPKLNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPackingList WITH NOCHECK ADD 
CONSTRAINT TPKLNo PRIMARY KEY CLUSTERED 
(
TPKLNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TPackingListMB ALTER COLUMN TPKMLn INT NOT NULL 
GO

ALTER TABLE VS4TPackingListMB ALTER COLUMN TPKMTPKLNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPackingListMB WITH NOCHECK ADD 
CONSTRAINT TPKMLn PRIMARY KEY CLUSTERED 
(
TPKMLn,TPKMTPKLNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TPallet ALTER COLUMN TPltCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPallet WITH NOCHECK ADD 
CONSTRAINT TPltCode PRIMARY KEY CLUSTERED 
(
TPltCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TPAMB ALTER COLUMN TPAMTPADNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPAMB ALTER COLUMN TPAMTPSDNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPAMB ALTER COLUMN TPAMLn INT NOT NULL 
GO

ALTER TABLE VS4TPAMB WITH NOCHECK ADD 
CONSTRAINT TPAMTPADNo PRIMARY KEY CLUSTERED 
(
TPAMTPADNo,TPAMTPSDNo,TPAMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TParameter ALTER COLUMN TParTCmGAlias NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TParameter ALTER COLUMN TParAlias NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TParameter WITH NOCHECK ADD 
CONSTRAINT TParTCmGAlias PRIMARY KEY CLUSTERED 
(
TParTCmGAlias,TParAlias
) ON [PRIMARY]
GO

ALTER TABLE VS4TPayment ALTER COLUMN TPymCode NVARCHAR (15) NOT NULL 
GO

ALTER TABLE VS4TPayment WITH NOCHECK ADD 
CONSTRAINT TPymCode PRIMARY KEY CLUSTERED 
(
TPymCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TPaymentType ALTER COLUMN TPyTAlias NVARCHAR (15) NOT NULL 
GO

ALTER TABLE VS4TPaymentType WITH NOCHECK ADD 
CONSTRAINT TPyTAlias PRIMARY KEY CLUSTERED 
(
TPyTAlias
) ON [PRIMARY]
GO

ALTER TABLE VS4TPayPeriodType ALTER COLUMN TPPTCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPayPeriodType WITH NOCHECK ADD 
CONSTRAINT TPPTCode PRIMARY KEY CLUSTERED 
(
TPPTCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TPCR ALTER COLUMN TPCRNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPCR WITH NOCHECK ADD 
CONSTRAINT TPCRNo PRIMARY KEY CLUSTERED 
(
TPCRNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TPCRMB ALTER COLUMN TPMBLn INT NOT NULL 
GO

ALTER TABLE VS4TPCRMB ALTER COLUMN TPMBTPCRNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPCRMB WITH NOCHECK ADD 
CONSTRAINT TPMBLn PRIMARY KEY CLUSTERED 
(
TPMBLn,TPMBTPCRNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TPlace ALTER COLUMN TPlaID INT NOT NULL 
GO

ALTER TABLE VS4TPlace WITH NOCHECK ADD 
CONSTRAINT TPlaID PRIMARY KEY CLUSTERED 
(
TPlaID
) ON [PRIMARY]
GO

ALTER TABLE VS4TPO ALTER COLUMN TPODNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPO WITH NOCHECK ADD 
CONSTRAINT TPODNo PRIMARY KEY CLUSTERED 
(
TPODNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TPOBook ALTER COLUMN TPOKCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPOBook WITH NOCHECK ADD 
CONSTRAINT TPOKCode PRIMARY KEY CLUSTERED 
(
TPOKCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TPODelivery ALTER COLUMN TPDETPOBTPODNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPODelivery ALTER COLUMN TPDETPOBLn INT NOT NULL 
GO

ALTER TABLE VS4TPODelivery ALTER COLUMN TPDELn INT NOT NULL 
GO

ALTER TABLE VS4TPODelivery WITH NOCHECK ADD 
CONSTRAINT TPDETPOBTPODNo PRIMARY KEY CLUSTERED 
(
TPDETPOBTPODNo,TPDETPOBLn,TPDELn
) ON [PRIMARY]
GO

ALTER TABLE VS4TPOMB ALTER COLUMN TPOBLn INT NOT NULL 
GO

ALTER TABLE VS4TPOMB ALTER COLUMN TPOBTPODNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPOMB WITH NOCHECK ADD 
CONSTRAINT TPOBLn PRIMARY KEY CLUSTERED 
(
TPOBLn,TPOBTPODNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TPOMBAOL ALTER COLUMN TPOATPOBTPODNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPOMBAOL ALTER COLUMN TPOATPOBLn INT NOT NULL 
GO

ALTER TABLE VS4TPOMBAOL WITH NOCHECK ADD 
CONSTRAINT TPOATPOBTPODNo PRIMARY KEY CLUSTERED 
(
TPOATPOBTPODNo,TPOATPOBLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TPOPayPeriod ALTER COLUMN TPPPTPODNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPOPayPeriod ALTER COLUMN TPPPLn SMALLINT NOT NULL 
GO

ALTER TABLE VS4TPOPayPeriod WITH NOCHECK ADD 
CONSTRAINT TPPPTPODNo PRIMARY KEY CLUSTERED 
(
TPPPTPODNo,TPPPLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TPOPSaleOut ALTER COLUMN TPPSNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPOPSaleOut WITH NOCHECK ADD 
CONSTRAINT TPPSNo PRIMARY KEY CLUSTERED 
(
TPPSNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TPOPScrap ALTER COLUMN TPScCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPOPScrap WITH NOCHECK ADD 
CONSTRAINT TPScCode PRIMARY KEY CLUSTERED 
(
TPScCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TPOPTrans ALTER COLUMN TPPDNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPOPTrans WITH NOCHECK ADD 
CONSTRAINT TPPDNo PRIMARY KEY CLUSTERED 
(
TPPDNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TPOPTransMB ALTER COLUMN TPTBTPPDNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPOPTransMB ALTER COLUMN TPTBLn INT NOT NULL 
GO

ALTER TABLE VS4TPOPTransMB ALTER COLUMN TPTBBalanceNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPOPTransMB WITH NOCHECK ADD 
CONSTRAINT TPTBTPPDNo PRIMARY KEY CLUSTERED 
(
TPTBTPPDNo,TPTBLn,TPTBBalanceNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TPOS ALTER COLUMN TPOSCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPOS WITH NOCHECK ADD 
CONSTRAINT TPOSCode PRIMARY KEY CLUSTERED 
(
TPOSCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TPOSBook ALTER COLUMN TPBKCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPOSBook WITH NOCHECK ADD 
CONSTRAINT TPBKCode PRIMARY KEY CLUSTERED 
(
TPBKCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TPosition ALTER COLUMN TPstCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPosition WITH NOCHECK ADD 
CONSTRAINT TPstCode PRIMARY KEY CLUSTERED 
(
TPstCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TPositionGroup ALTER COLUMN TPgpCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPositionGroup WITH NOCHECK ADD 
CONSTRAINT TPgpCode PRIMARY KEY CLUSTERED 
(
TPgpCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TPOSLastPrice ALTER COLUMN TPLPTPmtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPOSLastPrice ALTER COLUMN TPLPTPOSCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPOSLastPrice ALTER COLUMN TPLPFromQuantity FLOAT NOT NULL 
GO

ALTER TABLE VS4TPOSLastPrice ALTER COLUMN TPLPTUntCode NVARCHAR (15) NOT NULL 
GO

ALTER TABLE VS4TPOSLastPrice ALTER COLUMN TPLPTARGCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPOSLastPrice ALTER COLUMN TPLPTARNCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPOSLastPrice WITH NOCHECK ADD 
CONSTRAINT TPLPTPmtCode PRIMARY KEY CLUSTERED 
(
TPLPTPmtCode,TPLPTPOSCode,TPLPFromQuantity,TPLPTUntCode,TPLPTARGCode,TPLPTARNCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TPOSLPQueue ALTER COLUMN TPLQTPOSCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPOSLPQueue WITH NOCHECK ADD 
CONSTRAINT TPLQTPOSCode PRIMARY KEY CLUSTERED 
(
TPLQTPOSCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TPOSMB ALTER COLUMN TPoMTPOSCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPOSMB ALTER COLUMN TPoMTPdtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPOSMB WITH NOCHECK ADD 
CONSTRAINT TPoMTPOSCode PRIMARY KEY CLUSTERED 
(
TPoMTPOSCode,TPoMTPdtCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TPOSSaleGroup ALTER COLUMN TPSGCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPOSSaleGroup WITH NOCHECK ADD 
CONSTRAINT TPSGCode PRIMARY KEY CLUSTERED 
(
TPSGCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TPOSTrans ALTER COLUMN TPTANo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPOSTrans WITH NOCHECK ADD 
CONSTRAINT TPTANo PRIMARY KEY CLUSTERED 
(
TPTANo
) ON [PRIMARY]
GO

ALTER TABLE VS4TPOSTransEmp ALTER COLUMN TPTETPTANo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPOSTransEmp ALTER COLUMN TPTELn SMALLINT NOT NULL 
GO

ALTER TABLE VS4TPOSTransEmp WITH NOCHECK ADD 
CONSTRAINT TPTETPTANo PRIMARY KEY CLUSTERED 
(
TPTETPTANo,TPTELn
) ON [PRIMARY]
GO

ALTER TABLE VS4TPOSTransfer ALTER COLUMN TPTRNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPOSTransfer WITH NOCHECK ADD 
CONSTRAINT TPTRNo PRIMARY KEY CLUSTERED 
(
TPTRNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TPOSTransferMB ALTER COLUMN TPTMTPTRNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPOSTransferMB ALTER COLUMN TPTMLn SMALLINT NOT NULL 
GO

ALTER TABLE VS4TPOSTransferMB WITH NOCHECK ADD 
CONSTRAINT TPTMTPTRNo PRIMARY KEY CLUSTERED 
(
TPTMTPTRNo,TPTMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TPOSTransGuide ALTER COLUMN TPTGTPTANo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPOSTransGuide ALTER COLUMN TPTGLn SMALLINT NOT NULL 
GO

ALTER TABLE VS4TPOSTransGuide WITH NOCHECK ADD 
CONSTRAINT TPTGTPTANo PRIMARY KEY CLUSTERED 
(
TPTGTPTANo,TPTGLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TPOSTransPay ALTER COLUMN TPPyTPTANo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPOSTransPay ALTER COLUMN TPPyLn INT NOT NULL 
GO

ALTER TABLE VS4TPOSTransPay WITH NOCHECK ADD 
CONSTRAINT TPPyTPTANo PRIMARY KEY CLUSTERED 
(
TPPyTPTANo,TPPyLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TPOSTransSub ALTER COLUMN TPTSTPTANo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPOSTransSub ALTER COLUMN TPTSLn SMALLINT NOT NULL 
GO

ALTER TABLE VS4TPOSTransSub WITH NOCHECK ADD 
CONSTRAINT TPTSTPTANo PRIMARY KEY CLUSTERED 
(
TPTSTPTANo,TPTSLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TPQ ALTER COLUMN TPQDNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPQ WITH NOCHECK ADD 
CONSTRAINT TPQDNo PRIMARY KEY CLUSTERED 
(
TPQDNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TPQMB ALTER COLUMN TPQMTPQDNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPQMB ALTER COLUMN TPQMLn INT NOT NULL 
GO

ALTER TABLE VS4TPQMB WITH NOCHECK ADD 
CONSTRAINT TPQMTPQDNo PRIMARY KEY CLUSTERED 
(
TPQMTPQDNo,TPQMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TPR ALTER COLUMN TPRDNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPR WITH NOCHECK ADD 
CONSTRAINT TPRDNo PRIMARY KEY CLUSTERED 
(
TPRDNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TPRBook ALTER COLUMN TPRBCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPRBook WITH NOCHECK ADD 
CONSTRAINT TPRBCode PRIMARY KEY CLUSTERED 
(
TPRBCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TPriceFormula ALTER COLUMN TPFlCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPriceFormula WITH NOCHECK ADD 
CONSTRAINT TPFlCode PRIMARY KEY CLUSTERED 
(
TPFlCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TPricelist ALTER COLUMN TPPLNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPricelist WITH NOCHECK ADD 
CONSTRAINT TPPLNo PRIMARY KEY CLUSTERED 
(
TPPLNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TPricelistMB ALTER COLUMN TPPMTPPLNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPricelistMB ALTER COLUMN TPPMLn INT NOT NULL 
GO

ALTER TABLE VS4TPricelistMB WITH NOCHECK ADD 
CONSTRAINT TPPMTPPLNo PRIMARY KEY CLUSTERED 
(
TPPMTPPLNo,TPPMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TPRMB ALTER COLUMN TPRMTPRDNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPRMB ALTER COLUMN TPRMLn INT NOT NULL 
GO

ALTER TABLE VS4TPRMB WITH NOCHECK ADD 
CONSTRAINT TPRMTPRDNo PRIMARY KEY CLUSTERED 
(
TPRMTPRDNo,TPRMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TProduct ALTER COLUMN TPdtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProduct WITH NOCHECK ADD 
CONSTRAINT TPdtCode PRIMARY KEY CLUSTERED 
(
TPdtCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TProduct2 ALTER COLUMN TPd2TPdtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProduct2 ALTER COLUMN TPd2Ln INT NOT NULL 
GO

ALTER TABLE VS4TProduct2 WITH NOCHECK ADD 
CONSTRAINT TPd2TPdtCode PRIMARY KEY CLUSTERED 
(
TPd2TPdtCode,TPd2Ln
) ON [PRIMARY]
GO

ALTER TABLE VS4TProductAsset ALTER COLUMN TPM2TPOSCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProductAsset ALTER COLUMN TPM2TAssCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProductAsset WITH NOCHECK ADD 
CONSTRAINT TPM2TPOSCode PRIMARY KEY CLUSTERED 
(
TPM2TPOSCode,TPM2TAssCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TProductBook ALTER COLUMN TPBGTPdtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProductBook ALTER COLUMN TPBGLn INT NOT NULL 
GO

ALTER TABLE VS4TProductBook WITH NOCHECK ADD 
CONSTRAINT TPBGTPdtCode PRIMARY KEY CLUSTERED 
(
TPBGTPdtCode,TPBGLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TProductBookDT ALTER COLUMN TBDtTPdtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProductBookDT ALTER COLUMN TBDtLn INT NOT NULL 
GO

ALTER TABLE VS4TProductBookDT WITH NOCHECK ADD 
CONSTRAINT TBDtTPdtCode PRIMARY KEY CLUSTERED 
(
TBDtTPdtCode,TBDtLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TProductCalcTyp ALTER COLUMN TPCTAlias NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProductCalcTyp WITH NOCHECK ADD 
CONSTRAINT TPCTAlias PRIMARY KEY CLUSTERED 
(
TPCTAlias
) ON [PRIMARY]
GO

ALTER TABLE VS4TProductCost ALTER COLUMN TPMBTPdtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProductCost ALTER COLUMN TPMBLn INT NOT NULL 
GO

ALTER TABLE VS4TProductCost WITH NOCHECK ADD 
CONSTRAINT TPMBTPdtCode PRIMARY KEY CLUSTERED 
(
TPMBTPdtCode,TPMBLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TProductDL ALTER COLUMN TPLBTPdtCode NVARCHAR (50) NOT NULL 
GO

ALTER TABLE VS4TProductDL ALTER COLUMN TPLBTSpdStep INT NOT NULL 
GO

ALTER TABLE VS4TProductDL ALTER COLUMN TPLBLn INT NOT NULL 
GO

ALTER TABLE VS4TProductDL WITH NOCHECK ADD 
CONSTRAINT TPLBTPdtCode PRIMARY KEY CLUSTERED 
(
TPLBTPdtCode,TPLBTSpdStep,TPLBLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TProductFlight ALTER COLUMN TPFgTPdtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProductFlight ALTER COLUMN TPFgLn INT NOT NULL 
GO

ALTER TABLE VS4TProductFlight WITH NOCHECK ADD 
CONSTRAINT TPFgTPdtCode PRIMARY KEY CLUSTERED 
(
TPFgTPdtCode,TPFgLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TProductGroup1 ALTER COLUMN TPG1Code NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProductGroup1 WITH NOCHECK ADD 
CONSTRAINT TPG1Code PRIMARY KEY CLUSTERED 
(
TPG1Code
) ON [PRIMARY]
GO

ALTER TABLE VS4TProductGroup2 ALTER COLUMN TPG2Code NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProductGroup2 WITH NOCHECK ADD 
CONSTRAINT TPG2Code PRIMARY KEY CLUSTERED 
(
TPG2Code
) ON [PRIMARY]
GO

ALTER TABLE VS4TProductGroup3 ALTER COLUMN TPG3Code NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProductGroup3 WITH NOCHECK ADD 
CONSTRAINT TPG3Code PRIMARY KEY CLUSTERED 
(
TPG3Code
) ON [PRIMARY]
GO

ALTER TABLE VS4TProductGroup4 ALTER COLUMN TPG4Code NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProductGroup4 WITH NOCHECK ADD 
CONSTRAINT TPG4Code PRIMARY KEY CLUSTERED 
(
TPG4Code
) ON [PRIMARY]
GO

ALTER TABLE VS4TProductImage ALTER COLUMN TPImTPdtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProductImage ALTER COLUMN TPImCode INT NOT NULL 
GO

ALTER TABLE VS4TProductImage WITH NOCHECK ADD 
CONSTRAINT TPImTPdtCode PRIMARY KEY CLUSTERED 
(
TPImTPdtCode,TPImCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TProductItin ALTER COLUMN TPITTPdtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProductItin ALTER COLUMN TPITLn INT NOT NULL 
GO

ALTER TABLE VS4TProductItin WITH NOCHECK ADD 
CONSTRAINT TPITTPdtCode PRIMARY KEY CLUSTERED 
(
TPITTPdtCode,TPITLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TProductLeadTim ALTER COLUMN TPLtTPdtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProductLeadTim ALTER COLUMN TPLtLn INT NOT NULL 
GO

ALTER TABLE VS4TProductLeadTim WITH NOCHECK ADD 
CONSTRAINT TPLtTPdtCode PRIMARY KEY CLUSTERED 
(
TPLtTPdtCode,TPLtLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TProductLine ALTER COLUMN TPdLCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProductLine WITH NOCHECK ADD 
CONSTRAINT TPdLCode PRIMARY KEY CLUSTERED 
(
TPdLCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TProductLineMB ALTER COLUMN TPLMTPDLCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProductLineMB ALTER COLUMN TPLMTPSECode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProductLineMB WITH NOCHECK ADD 
CONSTRAINT TPLMTPDLCode PRIMARY KEY CLUSTERED 
(
TPLMTPDLCode,TPLMTPSECode
) ON [PRIMARY]
GO

ALTER TABLE VS4TProductMat ALTER COLUMN TPMtTPdtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProductMat ALTER COLUMN TPMtTSpdStep INT NOT NULL 
GO

ALTER TABLE VS4TProductMat ALTER COLUMN TPMtLn INT NOT NULL 
GO

ALTER TABLE VS4TProductMat WITH NOCHECK ADD 
CONSTRAINT TPMtTPdtCode PRIMARY KEY CLUSTERED 
(
TPMtTPdtCode,TPMtTSpdStep,TPMtLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TProductMB ALTER COLUMN TPDMTPdtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProductMB ALTER COLUMN TPDMLn INT NOT NULL 
GO

ALTER TABLE VS4TProductMB WITH NOCHECK ADD 
CONSTRAINT TPDMTPdtCode PRIMARY KEY CLUSTERED 
(
TPDMTPdtCode,TPDMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TProductMethod ALTER COLUMN TSpdTPdtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProductMethod ALTER COLUMN TSpdStep INT NOT NULL 
GO

ALTER TABLE VS4TProductMethod WITH NOCHECK ADD 
CONSTRAINT TSpdTPdtCode PRIMARY KEY CLUSTERED 
(
TSpdTPdtCode,TSpdStep
) ON [PRIMARY]
GO

ALTER TABLE VS4TProductMinor ALTER COLUMN TPMrTPdtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProductMinor ALTER COLUMN TPMrTSpdStep INT NOT NULL 
GO

ALTER TABLE VS4TProductMinor ALTER COLUMN TPMrLn INT NOT NULL 
GO

ALTER TABLE VS4TProductMinor WITH NOCHECK ADD 
CONSTRAINT TPMrTPdtCode PRIMARY KEY CLUSTERED 
(
TPMrTPdtCode,TPMrTSpdStep,TPMrLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TProductNote ALTER COLUMN TPDNTPdtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProductNote ALTER COLUMN TPDNLn INT NOT NULL 
GO

ALTER TABLE VS4TProductNote WITH NOCHECK ADD 
CONSTRAINT TPDNTPdtCode PRIMARY KEY CLUSTERED 
(
TPDNTPdtCode,TPDNLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TProductOH ALTER COLUMN TPOHTPdtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProductOH ALTER COLUMN TPOHTSpdStep INT NOT NULL 
GO

ALTER TABLE VS4TProductOH ALTER COLUMN TPOHLn INT NOT NULL 
GO

ALTER TABLE VS4TProductOH WITH NOCHECK ADD 
CONSTRAINT TPOHTPdtCode PRIMARY KEY CLUSTERED 
(
TPOHTPdtCode,TPOHTSpdStep,TPOHLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TProductPAX ALTER COLUMN TPSPTPdtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProductPAX ALTER COLUMN TPSPPax INT NOT NULL 
GO

ALTER TABLE VS4TProductPAX WITH NOCHECK ADD 
CONSTRAINT TPSPTPdtCode PRIMARY KEY CLUSTERED 
(
TPSPTPdtCode,TPSPPax
) ON [PRIMARY]
GO

ALTER TABLE VS4TProductPlace ALTER COLUMN TPAPTPdtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProductPlace ALTER COLUMN TPAPLn INT NOT NULL 
GO

ALTER TABLE VS4TProductPlace WITH NOCHECK ADD 
CONSTRAINT TPAPTPdtCode PRIMARY KEY CLUSTERED 
(
TPAPTPdtCode,TPAPLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TProductPURType ALTER COLUMN TPPuCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProductPURType WITH NOCHECK ADD 
CONSTRAINT TPPuCode PRIMARY KEY CLUSTERED 
(
TPPuCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TProductRelate ALTER COLUMN TPdRTPdtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProductRelate ALTER COLUMN TPdRTPdtCode2 NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProductRelate WITH NOCHECK ADD 
CONSTRAINT TPdRTPdtCode PRIMARY KEY CLUSTERED 
(
TPdRTPdtCode,TPdRTPdtCode2
) ON [PRIMARY]
GO

ALTER TABLE VS4TProductSafeS ALTER COLUMN TPSSTPdtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProductSafeS ALTER COLUMN TPSSTBraCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProductSafeS WITH NOCHECK ADD 
CONSTRAINT TPSSTPdtCode PRIMARY KEY CLUSTERED 
(
TPSSTPdtCode,TPSSTBraCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TProductSec2 ALTER COLUMN TPS2Code NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProductSec2 WITH NOCHECK ADD 
CONSTRAINT TPS2Code PRIMARY KEY CLUSTERED 
(
TPS2Code
) ON [PRIMARY]
GO

ALTER TABLE VS4TProductSec3 ALTER COLUMN TPS3Code NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProductSec3 WITH NOCHECK ADD 
CONSTRAINT TPS3Code PRIMARY KEY CLUSTERED 
(
TPS3Code
) ON [PRIMARY]
GO

ALTER TABLE VS4TProductSec4 ALTER COLUMN TPS4Code NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProductSec4 WITH NOCHECK ADD 
CONSTRAINT TPS4Code PRIMARY KEY CLUSTERED 
(
TPS4Code
) ON [PRIMARY]
GO

ALTER TABLE VS4TProductSection ALTER COLUMN TPSECode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProductSection WITH NOCHECK ADD 
CONSTRAINT TPSECode PRIMARY KEY CLUSTERED 
(
TPSECode
) ON [PRIMARY]
GO

ALTER TABLE VS4TProductSecType ALTER COLUMN TPETCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProductSecType WITH NOCHECK ADD 
CONSTRAINT TPETCode PRIMARY KEY CLUSTERED 
(
TPETCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TProductStat ALTER COLUMN TPMSTPdtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProductStat ALTER COLUMN TPMSLn INT NOT NULL 
GO

ALTER TABLE VS4TProductStat WITH NOCHECK ADD 
CONSTRAINT TPMSTPdtCode PRIMARY KEY CLUSTERED 
(
TPMSTPdtCode,TPMSLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TProductSub ALTER COLUMN TPdSTPdtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProductSub ALTER COLUMN TPdSLn INT NOT NULL 
GO

ALTER TABLE VS4TProductSub WITH NOCHECK ADD 
CONSTRAINT TPdSTPdtCode PRIMARY KEY CLUSTERED 
(
TPdSTPdtCode,TPdSLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TProductSupList ALTER COLUMN TPSLTPdtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProductSupList ALTER COLUMN TPSLLn INT NOT NULL 
GO

ALTER TABLE VS4TProductSupList WITH NOCHECK ADD 
CONSTRAINT TPSLTPdtCode PRIMARY KEY CLUSTERED 
(
TPSLTPdtCode,TPSLLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TProductTime ALTER COLUMN TPTITPdtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProductTime ALTER COLUMN TPTILn INT NOT NULL 
GO

ALTER TABLE VS4TProductTime WITH NOCHECK ADD 
CONSTRAINT TPTITPdtCode PRIMARY KEY CLUSTERED 
(
TPTITPdtCode,TPTILn
) ON [PRIMARY]
GO

ALTER TABLE VS4TProductType ALTER COLUMN TPTTCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProductType WITH NOCHECK ADD 
CONSTRAINT TPTTCode PRIMARY KEY CLUSTERED 
(
TPTTCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TProductUnit ALTER COLUMN TPDUTPdtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProductUnit ALTER COLUMN TPDUTUntCode NVARCHAR (15) NOT NULL 
GO

ALTER TABLE VS4TProductUnit ALTER COLUMN TPDURatio FLOAT NOT NULL 
GO

ALTER TABLE VS4TProductUnit WITH NOCHECK ADD 
CONSTRAINT TPDUTPdtCode PRIMARY KEY CLUSTERED 
(
TPDUTPdtCode,TPDUTUntCode,TPDURatio
) ON [PRIMARY]
GO

ALTER TABLE VS4TProductVender ALTER COLUMN TPdVTPdtcode NVARCHAR (255) NOT NULL 
GO

ALTER TABLE VS4TProductVender ALTER COLUMN TPdVTAPNCode NVARCHAR (255) NOT NULL 
GO

ALTER TABLE VS4TProductVender ALTER COLUMN TPdVLastPTUntCode NVARCHAR (10) NOT NULL 
GO

ALTER TABLE VS4TProductVender WITH NOCHECK ADD 
CONSTRAINT TPdVTPdtcode PRIMARY KEY CLUSTERED 
(
TPdVTPdtcode,TPdVTAPNCode,TPdVLastPTUntCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TProject ALTER COLUMN TPrjCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProject WITH NOCHECK ADD 
CONSTRAINT TPrjCode PRIMARY KEY CLUSTERED 
(
TPrjCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TProjectBOQ ALTER COLUMN TP2QTPHSTPrjCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProjectBOQ ALTER COLUMN TP2QTPHSLn INT NOT NULL 
GO

ALTER TABLE VS4TProjectBOQ ALTER COLUMN TP2QTBOQNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProjectBOQ WITH NOCHECK ADD 
CONSTRAINT TP2QTPHSTPrjCode PRIMARY KEY CLUSTERED 
(
TP2QTPHSTPrjCode,TP2QTPHSLn,TP2QTBOQNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TProjectPhase ALTER COLUMN TPHSTPrjCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProjectPhase ALTER COLUMN TPHSLn INT NOT NULL 
GO

ALTER TABLE VS4TProjectPhase WITH NOCHECK ADD 
CONSTRAINT TPHSTPrjCode PRIMARY KEY CLUSTERED 
(
TPHSTPrjCode,TPHSLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TProjectType ALTER COLUMN TPjTCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TProjectType WITH NOCHECK ADD 
CONSTRAINT TPjTCode PRIMARY KEY CLUSTERED 
(
TPjTCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TPromotion ALTER COLUMN TProNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPromotion WITH NOCHECK ADD 
CONSTRAINT TProNo PRIMARY KEY CLUSTERED 
(
TProNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TPromotionMB ALTER COLUMN TPMMTProNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPromotionMB ALTER COLUMN TPMMLn INT NOT NULL 
GO

ALTER TABLE VS4TPromotionMB WITH NOCHECK ADD 
CONSTRAINT TPMMTProNo PRIMARY KEY CLUSTERED 
(
TPMMTProNo,TPMMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TProvince ALTER COLUMN TPrvCode NVARCHAR (3) NOT NULL 
GO

ALTER TABLE VS4TProvince WITH NOCHECK ADD 
CONSTRAINT TPrvCode PRIMARY KEY CLUSTERED 
(
TPrvCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TPS ALTER COLUMN TPSDNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPS WITH NOCHECK ADD 
CONSTRAINT TPSDNo PRIMARY KEY CLUSTERED 
(
TPSDNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TPSMB ALTER COLUMN TPSMLn INT NOT NULL 
GO

ALTER TABLE VS4TPSMB ALTER COLUMN TPSMTPSDNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPSMB WITH NOCHECK ADD 
CONSTRAINT TPSMLn PRIMARY KEY CLUSTERED 
(
TPSMLn,TPSMTPSDNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TPurPriceList ALTER COLUMN TPUPNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPurPriceList WITH NOCHECK ADD 
CONSTRAINT TPUPNo PRIMARY KEY CLUSTERED 
(
TPUPNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TPurPriceListMB ALTER COLUMN TPUMTPUPNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TPurPriceListMB ALTER COLUMN TPUMLn INT NOT NULL 
GO

ALTER TABLE VS4TPurPriceListMB WITH NOCHECK ADD 
CONSTRAINT TPUMTPUPNo PRIMARY KEY CLUSTERED 
(
TPUMTPUPNo,TPUMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TQuickProduct ALTER COLUMN TQPdNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TQuickProduct WITH NOCHECK ADD 
CONSTRAINT TQPdNo PRIMARY KEY CLUSTERED 
(
TQPdNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TQuickProductMB ALTER COLUMN TQPMTQPdNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TQuickProductMB ALTER COLUMN TQPMLn INT NOT NULL 
GO

ALTER TABLE VS4TQuickProductMB WITH NOCHECK ADD 
CONSTRAINT TQPMTQPdNo PRIMARY KEY CLUSTERED 
(
TQPMTQPdNo,TQPMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TQuotation ALTER COLUMN TQuoNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TQuotation WITH NOCHECK ADD 
CONSTRAINT TQuoNo PRIMARY KEY CLUSTERED 
(
TQuoNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TQuotationMB ALTER COLUMN TQuBLn INT NOT NULL 
GO

ALTER TABLE VS4TQuotationMB ALTER COLUMN TQuBTQuoNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TQuotationMB WITH NOCHECK ADD 
CONSTRAINT TQuBLn PRIMARY KEY CLUSTERED 
(
TQuBLn,TQuBTQuoNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TQuotationSet ALTER COLUMN TQuSNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TQuotationSet WITH NOCHECK ADD 
CONSTRAINT TQuSNo PRIMARY KEY CLUSTERED 
(
TQuSNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TQuotationSetMB ALTER COLUMN TQSBTQuSNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TQuotationSetMB ALTER COLUMN TQSBTQuoNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TQuotationSetMB ALTER COLUMN TQSBLn INT NOT NULL 
GO

ALTER TABLE VS4TQuotationSetMB WITH NOCHECK ADD 
CONSTRAINT TQSBTQuSNo PRIMARY KEY CLUSTERED 
(
TQSBTQuSNo,TQSBTQuoNo,TQSBLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TReceipt ALTER COLUMN TRECNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TReceipt WITH NOCHECK ADD 
CONSTRAINT TRECNo PRIMARY KEY CLUSTERED 
(
TRECNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TReceivePdu ALTER COLUMN TRCPNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TReceivePdu WITH NOCHECK ADD 
CONSTRAINT TRCPNo PRIMARY KEY CLUSTERED 
(
TRCPNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TReceivePduMB ALTER COLUMN TRPMLn INT NOT NULL 
GO

ALTER TABLE VS4TReceivePduMB ALTER COLUMN TRPMTRCPNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TReceivePduMB WITH NOCHECK ADD 
CONSTRAINT TRPMLn PRIMARY KEY CLUSTERED 
(
TRPMLn,TRPMTRCPNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TRental ALTER COLUMN TRenNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TRental WITH NOCHECK ADD 
CONSTRAINT TRenNo PRIMARY KEY CLUSTERED 
(
TRenNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TReport ALTER COLUMN TRptAlias NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TReport WITH NOCHECK ADD 
CONSTRAINT TRptAlias PRIMARY KEY CLUSTERED 
(
TRptAlias
) ON [PRIMARY]
GO

ALTER TABLE VS4TReportMap ALTER COLUMN TRMpID INT NOT NULL 
GO

ALTER TABLE VS4TReportMap WITH NOCHECK ADD 
CONSTRAINT TRMpID PRIMARY KEY CLUSTERED 
(
TRMpID
) ON [PRIMARY]
GO

ALTER TABLE VS4TReviseEffect ALTER COLUMN TReETRevDocType NVARCHAR (10) NOT NULL 
GO

ALTER TABLE VS4TReviseEffect ALTER COLUMN TReETRevDocNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TReviseEffect ALTER COLUMN TReETRevNo SMALLINT NOT NULL 
GO

ALTER TABLE VS4TReviseEffect ALTER COLUMN TReEDocNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TReviseEffect WITH NOCHECK ADD 
CONSTRAINT TReETRevDocType PRIMARY KEY CLUSTERED 
(
TReETRevDocType,TReETRevDocNo,TReETRevNo,TReEDocNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TRevision ALTER COLUMN TRevDocType NVARCHAR (10) NOT NULL 
GO

ALTER TABLE VS4TRevision ALTER COLUMN TRevDocNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TRevision ALTER COLUMN TRevNo SMALLINT NOT NULL 
GO

ALTER TABLE VS4TRevision WITH NOCHECK ADD 
CONSTRAINT TRevDocType PRIMARY KEY CLUSTERED 
(
TRevDocType,TRevDocNo,TRevNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TRevisionGroup ALTER COLUMN TReGCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TRevisionGroup WITH NOCHECK ADD 
CONSTRAINT TReGCode PRIMARY KEY CLUSTERED 
(
TReGCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TRoute ALTER COLUMN TRouCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TRoute WITH NOCHECK ADD 
CONSTRAINT TRouCode PRIMARY KEY CLUSTERED 
(
TRouCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TSaleArea ALTER COLUMN TSAeCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TSaleArea WITH NOCHECK ADD 
CONSTRAINT TSAeCode PRIMARY KEY CLUSTERED 
(
TSAeCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TSaleForecast ALTER COLUMN TSFCTBraCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TSaleForecast ALTER COLUMN TSFCYear INT NOT NULL 
GO

ALTER TABLE VS4TSaleForecast ALTER COLUMN TSFCMonth INT NOT NULL 
GO

ALTER TABLE VS4TSaleForecast ALTER COLUMN TSFCTPdtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TSaleForecast ALTER COLUMN TSFCTEmpCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TSaleForecast WITH NOCHECK ADD 
CONSTRAINT TSFCTBraCode PRIMARY KEY CLUSTERED 
(
TSFCTBraCode,TSFCYear,TSFCMonth,TSFCTPdtCode,TSFCTEmpCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TSaleForecastDL ALTER COLUMN TSFDTSFCTBraCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TSaleForecastDL ALTER COLUMN TSFDTSFCYear INT NOT NULL 
GO

ALTER TABLE VS4TSaleForecastDL ALTER COLUMN TSFDTSFCMonth INT NOT NULL 
GO

ALTER TABLE VS4TSaleForecastDL ALTER COLUMN TSFDTSFCTPdtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TSaleForecastDL ALTER COLUMN TSFDTSFCTEmpCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TSaleForecastDL ALTER COLUMN TSFDStep INT NOT NULL 
GO

ALTER TABLE VS4TSaleForecastDL ALTER COLUMN TSFDLn INT NOT NULL 
GO

ALTER TABLE VS4TSaleForecastDL WITH NOCHECK ADD 
CONSTRAINT TSFDTSFCTBraCode PRIMARY KEY CLUSTERED 
(
TSFDTSFCTBraCode,TSFDTSFCYear,TSFDTSFCMonth,TSFDTSFCTPdtCode,TSFDTSFCTEmpCode,TSFDStep,TSFDLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TSaleForecastMB ALTER COLUMN TSFBTSFCTBraCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TSaleForecastMB ALTER COLUMN TSFBTSFCYear INT NOT NULL 
GO

ALTER TABLE VS4TSaleForecastMB ALTER COLUMN TSFBTSFCMonth INT NOT NULL 
GO

ALTER TABLE VS4TSaleForecastMB ALTER COLUMN TSFBTSFCTPdtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TSaleForecastMB ALTER COLUMN TSFBTSFCTEmpCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TSaleForecastMB ALTER COLUMN TSFBLn INT NOT NULL 
GO

ALTER TABLE VS4TSaleForecastMB WITH NOCHECK ADD 
CONSTRAINT TSFBTSFCTBraCode PRIMARY KEY CLUSTERED 
(
TSFBTSFCTBraCode,TSFBTSFCYear,TSFBTSFCMonth,TSFBTSFCTPdtCode,TSFBTSFCTEmpCode,TSFBLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TSaleForecastMT ALTER COLUMN TSFMTSFCTBraCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TSaleForecastMT ALTER COLUMN TSFMTSFCYear INT NOT NULL 
GO

ALTER TABLE VS4TSaleForecastMT ALTER COLUMN TSFMTSFCMonth INT NOT NULL 
GO

ALTER TABLE VS4TSaleForecastMT ALTER COLUMN TSFMTSFCTPdtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TSaleForecastMT ALTER COLUMN TSFMTSFCTEmpCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TSaleForecastMT ALTER COLUMN TSFMTSpdStep INT NOT NULL 
GO

ALTER TABLE VS4TSaleForecastMT ALTER COLUMN TSFMLn INT NOT NULL 
GO

ALTER TABLE VS4TSaleForecastMT WITH NOCHECK ADD 
CONSTRAINT TSFMTSFCTBraCode PRIMARY KEY CLUSTERED 
(
TSFMTSFCTBraCode,TSFMTSFCYear,TSFMTSFCMonth,TSFMTSFCTPdtCode,TSFMTSFCTEmpCode,TSFMTSpdStep,TSFMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TSaleTarget ALTER COLUMN TSTGNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TSaleTarget WITH NOCHECK ADD 
CONSTRAINT TSTGNo PRIMARY KEY CLUSTERED 
(
TSTGNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TSaleTargetMB ALTER COLUMN TSGMLn INT NOT NULL 
GO

ALTER TABLE VS4TSaleTargetMB ALTER COLUMN TSGMTSTGNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TSaleTargetMB WITH NOCHECK ADD 
CONSTRAINT TSGMLn PRIMARY KEY CLUSTERED 
(
TSGMLn,TSGMTSTGNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TSaleZone ALTER COLUMN TSZnCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TSaleZone WITH NOCHECK ADD 
CONSTRAINT TSZnCode PRIMARY KEY CLUSTERED 
(
TSZnCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TSaleZoneGroup ALTER COLUMN TSZGCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TSaleZoneGroup WITH NOCHECK ADD 
CONSTRAINT TSZGCode PRIMARY KEY CLUSTERED 
(
TSZGCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TSAR ALTER COLUMN TSARNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TSAR WITH NOCHECK ADD 
CONSTRAINT TSARNo PRIMARY KEY CLUSTERED 
(
TSARNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TSARMB ALTER COLUMN TSRBTSARNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TSARMB ALTER COLUMN TSRBLn INT NOT NULL 
GO

ALTER TABLE VS4TSARMB WITH NOCHECK ADD 
CONSTRAINT TSRBTSARNo PRIMARY KEY CLUSTERED 
(
TSRBTSARNo,TSRBLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TSARPatGroup ALTER COLUMN TSRGTSRPNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TSARPatGroup ALTER COLUMN TSRGLn INT NOT NULL 
GO

ALTER TABLE VS4TSARPatGroup WITH NOCHECK ADD 
CONSTRAINT TSRGTSRPNo PRIMARY KEY CLUSTERED 
(
TSRGTSRPNo,TSRGLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TSARPattern ALTER COLUMN TSRPNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TSARPattern WITH NOCHECK ADD 
CONSTRAINT TSRPNo PRIMARY KEY CLUSTERED 
(
TSRPNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TSARPatternMB ALTER COLUMN TSRMTSRGTSRPNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TSARPatternMB ALTER COLUMN TSRMTSRGLn INT NOT NULL 
GO

ALTER TABLE VS4TSARPatternMB ALTER COLUMN TSRMLn INT NOT NULL 
GO

ALTER TABLE VS4TSARPatternMB WITH NOCHECK ADD 
CONSTRAINT TSRMTSRGTSRPNo PRIMARY KEY CLUSTERED 
(
TSRMTSRGTSRPNo,TSRMTSRGLn,TSRMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TScrap ALTER COLUMN TLotCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TScrap WITH NOCHECK ADD 
CONSTRAINT TLotCode PRIMARY KEY CLUSTERED 
(
TLotCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TSection ALTER COLUMN TSecCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TSection WITH NOCHECK ADD 
CONSTRAINT TSecCode PRIMARY KEY CLUSTERED 
(
TSecCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TShipInstruct ALTER COLUMN TSPINo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TShipInstruct WITH NOCHECK ADD 
CONSTRAINT TSPINo PRIMARY KEY CLUSTERED 
(
TSPINo
) ON [PRIMARY]
GO

ALTER TABLE VS4TShipping ALTER COLUMN TSHPCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TShipping WITH NOCHECK ADD 
CONSTRAINT TSHPCode PRIMARY KEY CLUSTERED 
(
TSHPCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TSituation ALTER COLUMN TSitCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TSituation WITH NOCHECK ADD 
CONSTRAINT TSitCode PRIMARY KEY CLUSTERED 
(
TSitCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TSO ALTER COLUMN TSODNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TSO WITH NOCHECK ADD 
CONSTRAINT TSODNo PRIMARY KEY CLUSTERED 
(
TSODNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TSOBook ALTER COLUMN TSBKCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TSOBook WITH NOCHECK ADD 
CONSTRAINT TSBKCode PRIMARY KEY CLUSTERED 
(
TSBKCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TSODelivery ALTER COLUMN TMDSTSOBTSODNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TSODelivery ALTER COLUMN TMDSTSOBLn INT NOT NULL 
GO

ALTER TABLE VS4TSODelivery ALTER COLUMN TMDSLn INT NOT NULL 
GO

ALTER TABLE VS4TSODelivery WITH NOCHECK ADD 
CONSTRAINT TMDSTSOBTSODNo PRIMARY KEY CLUSTERED 
(
TMDSTSOBTSODNo,TMDSTSOBLn,TMDSLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TSOImigration ALTER COLUMN TIMGTPdtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TSOImigration ALTER COLUMN TIMGLn INT NOT NULL 
GO

ALTER TABLE VS4TSOImigration ALTER COLUMN TIMGTSODNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TSOImigration WITH NOCHECK ADD 
CONSTRAINT TIMGTPdtCode PRIMARY KEY CLUSTERED 
(
TIMGTPdtCode,TIMGLn,TIMGTSODNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TSOMB ALTER COLUMN TSOBLn INT NOT NULL 
GO

ALTER TABLE VS4TSOMB ALTER COLUMN TSOBTSODNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TSOMB WITH NOCHECK ADD 
CONSTRAINT TSOBLn PRIMARY KEY CLUSTERED 
(
TSOBLn,TSOBTSODNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TSOPassenger ALTER COLUMN TVSPTPdtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TSOPassenger ALTER COLUMN TVSPLn INT NOT NULL 
GO

ALTER TABLE VS4TSOPassenger ALTER COLUMN TVSPTSODNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TSOPassenger WITH NOCHECK ADD 
CONSTRAINT TVSPTPdtCode PRIMARY KEY CLUSTERED 
(
TVSPTPdtCode,TVSPLn,TVSPTSODNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TSOPayPeriod ALTER COLUMN TSPPTSODNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TSOPayPeriod ALTER COLUMN TSPPLn SMALLINT NOT NULL 
GO

ALTER TABLE VS4TSOPayPeriod WITH NOCHECK ADD 
CONSTRAINT TSPPTSODNo PRIMARY KEY CLUSTERED 
(
TSPPTSODNo,TSPPLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TSOProgress ALTER COLUMN TSOPID INT NOT NULL 
GO

ALTER TABLE VS4TSOProgress WITH NOCHECK ADD 
CONSTRAINT TSOPID PRIMARY KEY CLUSTERED 
(
TSOPID
) ON [PRIMARY]
GO

ALTER TABLE VS4TSSORate ALTER COLUMN TSSRCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TSSORate WITH NOCHECK ADD 
CONSTRAINT TSSRCode PRIMARY KEY CLUSTERED 
(
TSSRCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TStandard ALTER COLUMN TStdCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TStandard WITH NOCHECK ADD 
CONSTRAINT TStdCode PRIMARY KEY CLUSTERED 
(
TStdCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TState ALTER COLUMN TStaCode NVARCHAR (2) NOT NULL 
GO

ALTER TABLE VS4TState WITH NOCHECK ADD 
CONSTRAINT TStaCode PRIMARY KEY CLUSTERED 
(
TStaCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TStockNow ALTER COLUMN TSFNTLctCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TStockNow ALTER COLUMN TSFNTPdtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TStockNow ALTER COLUMN TSFNCustom1 NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TStockNow ALTER COLUMN TSFNSerialNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TStockNow ALTER COLUMN TSFNLotNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TStockNow ALTER COLUMN TSFNLotDate DATETIME NOT NULL 
GO

ALTER TABLE VS4TStockNow WITH NOCHECK ADD 
CONSTRAINT TSFNTLctCode PRIMARY KEY CLUSTERED 
(
TSFNTLctCode,TSFNTPdtCode,TSFNCustom1,TSFNSerialNo,TSFNLotNo,TSFNLotDate
) ON [PRIMARY]
GO

ALTER TABLE VS4TSwitchTime ALTER COLUMN TSwTNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TSwitchTime WITH NOCHECK ADD 
CONSTRAINT TSwTNo PRIMARY KEY CLUSTERED 
(
TSwTNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TSwitchTimeGp ALTER COLUMN TSwGNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TSwitchTimeGp WITH NOCHECK ADD 
CONSTRAINT TSwGNo PRIMARY KEY CLUSTERED 
(
TSwGNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TSwitchTimeGpMB ALTER COLUMN TSWMTSWGNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TSwitchTimeGpMB ALTER COLUMN TSWMLn INT NOT NULL 
GO

ALTER TABLE VS4TSwitchTimeGpMB WITH NOCHECK ADD 
CONSTRAINT TSWMTSWGNo PRIMARY KEY CLUSTERED 
(
TSWMTSWGNo,TSWMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TSwitchTimeMB ALTER COLUMN TSTMTSWTNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TSwitchTimeMB ALTER COLUMN TSTMLn INT NOT NULL 
GO

ALTER TABLE VS4TSwitchTimeMB WITH NOCHECK ADD 
CONSTRAINT TSTMTSWTNo PRIMARY KEY CLUSTERED 
(
TSTMTSWTNo,TSTMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TSystem ALTER COLUMN TSysID INT NOT NULL 
GO

ALTER TABLE VS4TSystem WITH NOCHECK ADD 
CONSTRAINT TSysID PRIMARY KEY CLUSTERED 
(
TSysID
) ON [PRIMARY]
GO

ALTER TABLE VS4TSystemBranch ALTER COLUMN TSyBID INT NOT NULL 
GO

ALTER TABLE VS4TSystemBranch WITH NOCHECK ADD 
CONSTRAINT TSyBID PRIMARY KEY CLUSTERED 
(
TSyBID
) ON [PRIMARY]
GO

ALTER TABLE VS4TSystemGroup ALTER COLUMN TSyGAlias NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TSystemGroup WITH NOCHECK ADD 
CONSTRAINT TSyGAlias PRIMARY KEY CLUSTERED 
(
TSyGAlias
) ON [PRIMARY]
GO

ALTER TABLE VS4TSystemUser ALTER COLUMN TSyUID INT NOT NULL 
GO

ALTER TABLE VS4TSystemUser WITH NOCHECK ADD 
CONSTRAINT TSyUID PRIMARY KEY CLUSTERED 
(
TSyUID
) ON [PRIMARY]
GO

ALTER TABLE VS4TTax ALTER COLUMN TTaxAlias NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TTax WITH NOCHECK ADD 
CONSTRAINT TTaxAlias PRIMARY KEY CLUSTERED 
(
TTaxAlias
) ON [PRIMARY]
GO

ALTER TABLE VS4TTaxBaseIncome ALTER COLUMN TTbCCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TTaxBaseIncome WITH NOCHECK ADD 
CONSTRAINT TTbCCode PRIMARY KEY CLUSTERED 
(
TTbCCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TTaxRate ALTER COLUMN TTxRTTaxAlias NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TTaxRate ALTER COLUMN TTxRFromBase FLOAT NOT NULL 
GO

ALTER TABLE VS4TTaxRate WITH NOCHECK ADD 
CONSTRAINT TTxRTTaxAlias PRIMARY KEY CLUSTERED 
(
TTxRTTaxAlias,TTxRFromBase
) ON [PRIMARY]
GO

ALTER TABLE VS4TTaxTrans ALTER COLUMN TTxTID INT NOT NULL 
GO

ALTER TABLE VS4TTaxTrans WITH NOCHECK ADD 
CONSTRAINT TTxTID PRIMARY KEY CLUSTERED 
(
TTxTID
) ON [PRIMARY]
GO

ALTER TABLE VS4TTeasuryMove ALTER COLUMN TTYMTACPTACYID INT NOT NULL 
GO

ALTER TABLE VS4TTeasuryMove ALTER COLUMN TTYMTACPID INT NOT NULL 
GO

ALTER TABLE VS4TTeasuryMove ALTER COLUMN TTYMTCBBNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TTeasuryMove WITH NOCHECK ADD 
CONSTRAINT TTYMTACPTACYID PRIMARY KEY CLUSTERED 
(
TTYMTACPTACYID,TTYMTACPID,TTYMTCBBNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TTeasuryTrans ALTER COLUMN TTeTNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TTeasuryTrans WITH NOCHECK ADD 
CONSTRAINT TTeTNo PRIMARY KEY CLUSTERED 
(
TTeTNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TTeasuryTransMB ALTER COLUMN TTTMTTeTNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TTeasuryTransMB ALTER COLUMN TTTMLn INT NOT NULL 
GO

ALTER TABLE VS4TTeasuryTransMB WITH NOCHECK ADD 
CONSTRAINT TTTMTTeTNo PRIMARY KEY CLUSTERED 
(
TTTMTTeTNo,TTTMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TTimeInput ALTER COLUMN TTIPID INT NOT NULL 
GO

ALTER TABLE VS4TTimeInput WITH NOCHECK ADD 
CONSTRAINT TTIPID PRIMARY KEY CLUSTERED 
(
TTIPID
) ON [PRIMARY]
GO

ALTER TABLE VS4TTimeInputCode ALTER COLUMN TTICType SMALLINT NOT NULL 
GO

ALTER TABLE VS4TTimeInputCode ALTER COLUMN TTICCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TTimeInputCode WITH NOCHECK ADD 
CONSTRAINT TTICType PRIMARY KEY CLUSTERED 
(
TTICType,TTICCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TTimeInputNote ALTER COLUMN TTINLN INT NOT NULL 
GO

ALTER TABLE VS4TTimeInputNote WITH NOCHECK ADD 
CONSTRAINT TTINLN PRIMARY KEY CLUSTERED 
(
TTINLN
) ON [PRIMARY]
GO

ALTER TABLE VS4TTitle ALTER COLUMN TTtlID INT NOT NULL 
GO

ALTER TABLE VS4TTitle WITH NOCHECK ADD 
CONSTRAINT TTtlID PRIMARY KEY CLUSTERED 
(
TTtlID
) ON [PRIMARY]
GO

ALTER TABLE VS4TTmpSelectSet ALTER COLUMN TTSSID INT NOT NULL 
GO

ALTER TABLE VS4TTmpSelectSet WITH NOCHECK ADD 
CONSTRAINT TTSSID PRIMARY KEY CLUSTERED 
(
TTSSID
) ON [PRIMARY]
GO

ALTER TABLE VS4TTmpSelectSetMB ALTER COLUMN TTSMID INT NOT NULL 
GO

ALTER TABLE VS4TTmpSelectSetMB WITH NOCHECK ADD 
CONSTRAINT TTSMID PRIMARY KEY CLUSTERED 
(
TTSMID
) ON [PRIMARY]
GO

ALTER TABLE VS4TTR ALTER COLUMN TTRDNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TTR WITH NOCHECK ADD 
CONSTRAINT TTRDNo PRIMARY KEY CLUSTERED 
(
TTRDNo
) ON [PRIMARY]
GO

ALTER TABLE VS4TTrainingCourse ALTER COLUMN TTrCCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TTrainingCourse WITH NOCHECK ADD 
CONSTRAINT TTrCCode PRIMARY KEY CLUSTERED 
(
TTrCCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TTrainingGroup ALTER COLUMN TTrGCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TTrainingGroup WITH NOCHECK ADD 
CONSTRAINT TTrGCode PRIMARY KEY CLUSTERED 
(
TTrGCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TTRMB ALTER COLUMN TTRMTTRDNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TTRMB ALTER COLUMN TTRMLn INT NOT NULL 
GO

ALTER TABLE VS4TTRMB WITH NOCHECK ADD 
CONSTRAINT TTRMTTRDNo PRIMARY KEY CLUSTERED 
(
TTRMTTRDNo,TTRMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TUnit ALTER COLUMN TUntCode NVARCHAR (15) NOT NULL 
GO

ALTER TABLE VS4TUnit WITH NOCHECK ADD 
CONSTRAINT TUntCode PRIMARY KEY CLUSTERED 
(
TUntCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TUnitGroup ALTER COLUMN TUnGAlias NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TUnitGroup WITH NOCHECK ADD 
CONSTRAINT TUnGAlias PRIMARY KEY CLUSTERED 
(
TUnGAlias
) ON [PRIMARY]
GO

ALTER TABLE VS4TUnitTransfer ALTER COLUMN TUTRTUntCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TUnitTransfer ALTER COLUMN TUTRToTUntCode NVARCHAR (15) NOT NULL 
GO

ALTER TABLE VS4TUnitTransfer WITH NOCHECK ADD 
CONSTRAINT TUTRTUntCode PRIMARY KEY CLUSTERED 
(
TUTRTUntCode,TUTRToTUntCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TUpdateHistory ALTER COLUMN TUPDID INT NOT NULL 
GO

ALTER TABLE VS4TUpdateHistory WITH NOCHECK ADD 
CONSTRAINT TUPDID PRIMARY KEY CLUSTERED 
(
TUPDID
) ON [PRIMARY]
GO

ALTER TABLE VS4TUser ALTER COLUMN TUsrID INT NOT NULL 
GO

ALTER TABLE VS4TUser WITH NOCHECK ADD 
CONSTRAINT TUsrID PRIMARY KEY CLUSTERED 
(
TUsrID
) ON [PRIMARY]
GO

ALTER TABLE VS4TUserAlert ALTER COLUMN TUsATUsrID INT NOT NULL 
GO

ALTER TABLE VS4TUserAlert ALTER COLUMN TUsATCmdID INT NOT NULL 
GO

ALTER TABLE VS4TUserAlert WITH NOCHECK ADD 
CONSTRAINT TUsATUsrID PRIMARY KEY CLUSTERED 
(
TUsATUsrID,TUsATCmdID
) ON [PRIMARY]
GO

ALTER TABLE VS4TUserBranch ALTER COLUMN TUsBTUsrID INT NOT NULL 
GO

ALTER TABLE VS4TUserBranch ALTER COLUMN TUsBTBraCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TUserBranch ALTER COLUMN TUsBTCmGAlias NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TUserBranch WITH NOCHECK ADD 
CONSTRAINT TUsBTUsrID PRIMARY KEY CLUSTERED 
(
TUsBTUsrID,TUsBTBraCode,TUsBTCmGAlias
) ON [PRIMARY]
GO

ALTER TABLE VS4TUserCommand ALTER COLUMN TUsCTUsrID INT NOT NULL 
GO

ALTER TABLE VS4TUserCommand ALTER COLUMN TUsCTCmdID INT NOT NULL 
GO

ALTER TABLE VS4TUserCommand WITH NOCHECK ADD 
CONSTRAINT TUsCTUsrID PRIMARY KEY CLUSTERED 
(
TUsCTUsrID,TUsCTCmdID
) ON [PRIMARY]
GO

ALTER TABLE VS4TUserEmployee ALTER COLUMN TUsETUsrID INT NOT NULL 
GO

ALTER TABLE VS4TUserEmployee ALTER COLUMN TUsETEmpCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TUserEmployee WITH NOCHECK ADD 
CONSTRAINT TUsETUsrID PRIMARY KEY CLUSTERED 
(
TUsETUsrID,TUsETEmpCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TUserEmpType ALTER COLUMN TUETTUsrID INT NOT NULL 
GO

ALTER TABLE VS4TUserEmpType ALTER COLUMN TUETTEmTCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TUserEmpType ALTER COLUMN TUETTCmGAlias NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TUserEmpType WITH NOCHECK ADD 
CONSTRAINT TUETTUsrID PRIMARY KEY CLUSTERED 
(
TUETTUsrID,TUETTEmTCode,TUETTCmGAlias
) ON [PRIMARY]
GO

ALTER TABLE VS4TUserPermiss ALTER COLUMN TUsPTCmdID INT NOT NULL 
GO

ALTER TABLE VS4TUserPermiss ALTER COLUMN TUsPTUsrID INT NOT NULL 
GO

ALTER TABLE VS4TUserPermiss WITH NOCHECK ADD 
CONSTRAINT TUsPTCmdID PRIMARY KEY CLUSTERED 
(
TUsPTCmdID,TUsPTUsrID
) ON [PRIMARY]
GO

ALTER TABLE VS4TVAT30 ALTER COLUMN TV30TTaxAlias NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TVAT30 ALTER COLUMN TV30Year INT NOT NULL 
GO

ALTER TABLE VS4TVAT30 ALTER COLUMN TV30Month INT NOT NULL 
GO

ALTER TABLE VS4TVAT30 ALTER COLUMN TV30Ln INT NOT NULL 
GO

ALTER TABLE VS4TVAT30 WITH NOCHECK ADD 
CONSTRAINT TV30TTaxAlias PRIMARY KEY CLUSTERED 
(
TV30TTaxAlias,TV30Year,TV30Month,TV30Ln
) ON [PRIMARY]
GO

ALTER TABLE VS4TVehicle ALTER COLUMN TVehCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TVehicle WITH NOCHECK ADD 
CONSTRAINT TVehCode PRIMARY KEY CLUSTERED 
(
TVehCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TVehicleRate ALTER COLUMN TVeRTVeTCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TVehicleRate ALTER COLUMN TVeRFromQuantity INT NOT NULL 
GO

ALTER TABLE VS4TVehicleRate ALTER COLUMN TVeRType INT NOT NULL 
GO

ALTER TABLE VS4TVehicleRate WITH NOCHECK ADD 
CONSTRAINT TVeRTVeTCode PRIMARY KEY CLUSTERED 
(
TVeRTVeTCode,TVeRFromQuantity,TVeRType
) ON [PRIMARY]
GO

ALTER TABLE VS4TVehicleType ALTER COLUMN TVeTCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TVehicleType WITH NOCHECK ADD 
CONSTRAINT TVeTCode PRIMARY KEY CLUSTERED 
(
TVeTCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TVisa ALTER COLUMN TVSATPdtCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TVisa ALTER COLUMN TVSALn INT NOT NULL 
GO

ALTER TABLE VS4TVisa WITH NOCHECK ADD 
CONSTRAINT TVSATPdtCode PRIMARY KEY CLUSTERED 
(
TVSATPdtCode,TVSALn
) ON [PRIMARY]
GO

ALTER TABLE VS4TWarehouse ALTER COLUMN TWahCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TWarehouse WITH NOCHECK ADD 
CONSTRAINT TWahCode PRIMARY KEY CLUSTERED 
(
TWahCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TWelfare ALTER COLUMN TWelCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TWelfare WITH NOCHECK ADD 
CONSTRAINT TWelCode PRIMARY KEY CLUSTERED 
(
TWelCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TWelfareGroup ALTER COLUMN TWfGCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TWelfareGroup WITH NOCHECK ADD 
CONSTRAINT TWfGCode PRIMARY KEY CLUSTERED 
(
TWfGCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TWorkflow ALTER COLUMN TWFWCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TWorkflow WITH NOCHECK ADD 
CONSTRAINT TWFWCode PRIMARY KEY CLUSTERED 
(
TWFWCode
) ON [PRIMARY]
GO

ALTER TABLE VS4TWorkflowData ALTER COLUMN TWFDDocNo NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TWorkflowData ALTER COLUMN TWFDTWFMTWFWCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TWorkflowData ALTER COLUMN TWFDTWFMLn INT NOT NULL 
GO

ALTER TABLE VS4TWorkflowData WITH NOCHECK ADD 
CONSTRAINT TWFDDocNo PRIMARY KEY CLUSTERED 
(
TWFDDocNo,TWFDTWFMTWFWCode,TWFDTWFMLn
) ON [PRIMARY]
GO

ALTER TABLE VS4TWorkflowMB ALTER COLUMN TWFMTWFWCode NVARCHAR (30) NOT NULL 
GO

ALTER TABLE VS4TWorkflowMB ALTER COLUMN TWFMLn INT NOT NULL 
GO

ALTER TABLE VS4TWorkflowMB WITH NOCHECK ADD 
CONSTRAINT TWFMTWFWCode PRIMARY KEY CLUSTERED 
(
TWFMTWFWCode,TWFMLn
) ON [PRIMARY]
GO

