drop table Project ; CREATE TABLE Project ( ID INT IDENTITY(1,1) PRIMARY KEY, Code NVARCHAR(500) NULL, Name NVARCHAR(1000) NULL, Remarks NVARCHAR(1000) NULL ); alter table invoice add ProjectName varchar(500), ProjectCode varchar(500);