69 lines
1.6 KiB
Transact-SQL
69 lines
1.6 KiB
Transact-SQL
ALTER TABLE Transfer_PunchlistFrom ADD Num_NO BigInt NULL
|
|
GO
|
|
|
|
ALTER TABLE Transfer_PunchlistFrom ADD System_No NVARCHAR(50) NULL
|
|
GO
|
|
|
|
ALTER TABLE Transfer_PunchlistFrom ADD Sub_Sys_No NVARCHAR(50) NULL
|
|
GO
|
|
|
|
ALTER TABLE Transfer_PunchlistFrom ADD Cat NVARCHAR(50) NULL
|
|
GO
|
|
|
|
ALTER TABLE Transfer_PunchlistFrom ADD Raised_By NVARCHAR(50) NULL
|
|
GO
|
|
|
|
ALTER TABLE Transfer_PunchlistFrom ADD Date_Raised datetime NULL
|
|
GO
|
|
|
|
ALTER TABLE Transfer_PunchlistFrom ADD Disc NVARCHAR(50) NULL
|
|
GO
|
|
|
|
ALTER TABLE Transfer_PunchlistFrom ADD IsEng bit NULL
|
|
GO
|
|
|
|
ALTER TABLE Transfer_PunchlistFrom ADD IsMatI bit NULL
|
|
GO
|
|
|
|
ALTER TABLE Transfer_PunchlistFrom ADD Punch_Type NVARCHAR(50) NULL
|
|
GO
|
|
|
|
ALTER TABLE Transfer_PunchlistFrom ADD Required_Date datetime NULL
|
|
GO
|
|
|
|
ALTER TABLE Transfer_PunchlistFrom ADD PIC NVARCHAR(50) NULL
|
|
GO
|
|
|
|
ALTER TABLE Transfer_PunchlistFrom ADD PIC_WUH NVARCHAR(50) NULL
|
|
GO
|
|
|
|
ALTER TABLE Transfer_PunchlistFrom ADD Correction_Action NVARCHAR(500) NULL
|
|
GO
|
|
|
|
ALTER TABLE Transfer_PunchlistFrom ADD Actual_Date datetime NULL
|
|
GO
|
|
|
|
ALTER TABLE Transfer_PunchlistFrom ADD Cleared_By NVARCHAR(50) NULL
|
|
GO
|
|
|
|
ALTER TABLE Transfer_PunchlistFrom ADD Cleared_Date datetime NULL
|
|
GO
|
|
|
|
ALTER TABLE Transfer_PunchlistFrom ADD Confirmed_By NVARCHAR(50) NULL
|
|
GO
|
|
|
|
ALTER TABLE Transfer_PunchlistFrom ADD Confirmed_Date datetime NULL
|
|
GO
|
|
|
|
ALTER TABLE Transfer_PunchlistFrom ADD Verified_By NVARCHAR(50) NULL
|
|
GO
|
|
|
|
ALTER TABLE Transfer_PunchlistFrom ADD Verified_Date datetime NULL
|
|
GO
|
|
|
|
ALTER TABLE Transfer_PunchlistFrom ADD [Status] NVARCHAR(50) NULL
|
|
GO
|
|
|
|
ALTER TABLE Transfer_PunchlistFrom ADD Remark NVARCHAR(500) NULL
|
|
GO
|