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