blob: 83c76e777472675ed8e72a3ac7b3063fdcd9541f (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
IF COL_LENGTH('[dbo].[parcela]', 'cri_data') IS NULL
BEGIN
ALTER TABLE [dbo].[parcela] ADD cri_data DATETIME2 NULL;
END
IF COL_LENGTH('[dbo].[parcela]', 'usuariocriacao') IS NULL
BEGIN
ALTER TABLE [dbo].[parcela] ADD usuariocriacao BIGINT NULL;
END
IF COL_LENGTH('[dbo].[parcela]', 'atu_data') IS NULL
BEGIN
ALTER TABLE [dbo].[parcela] ADD atu_data DATETIME2 NULL;
END
IF COL_LENGTH('[dbo].[parcela]', 'usuarioalteracao') IS NULL
BEGIN
ALTER TABLE [dbo].[parcela] ADD usuarioalteracao BIGINT NULL;
END
|
