ALTER TABLE VS4TProjectBOQ ADD
	TP2QTBOQNo nvarchar(30) NULL
GO
update VS4TProjectBOQ set TP2QTBOQNo='' where TP2QTBOQNo is null
GO
ALTER TABLE VS4TProjectBOQ 
	DROP CONSTRAINT PK_VS4TProjectBOQ 
GO
ALTER TABLE VS4TProjectBOQ ALTER COLUMN
	TP2QTBOQNo nvarchar(30) NOT NULL
GO
ALTER TABLE VS4TProjectBOQ  ADD CONSTRAINT
	PK_VS4TProjectBOQ  PRIMARY KEY CLUSTERED 
	(
	TP2QTPHSTPrjCode,
	TP2QTPHSLn,
	TP2QTBOQNo
	) ON [PRIMARY]
GO
ALTER TABLE dbo.VS4TProjectBOQ
	DROP COLUMN TP2QTPdtCode
GO