IF COL_LENGTH('dbo.asr_wrk_mast', 'container_no') IS NULL
|
BEGIN
|
ALTER TABLE [dbo].[asr_wrk_mast]
|
ADD [container_no] NVARCHAR(100) NULL;
|
END
|
GO
|
|
IF COL_LENGTH('dbo.asr_wrk_mast_log', 'container_no') IS NULL
|
BEGIN
|
ALTER TABLE [dbo].[asr_wrk_mast_log]
|
ADD [container_no] NVARCHAR(100) NULL;
|
END
|
GO
|
|
IF COL_LENGTH('dbo.asr_wrk_detl', 'teu') IS NULL
|
BEGIN
|
ALTER TABLE [dbo].[asr_wrk_detl]
|
ADD [teu] INT NULL;
|
END
|
GO
|
|
IF COL_LENGTH('dbo.asr_wrk_detl_log', 'teu') IS NULL
|
BEGIN
|
ALTER TABLE [dbo].[asr_wrk_detl_log]
|
ADD [teu] INT NULL;
|
END
|
GO
|
