blob: b201157dc53fac8a20c6b44e9958c7fd7f199d79 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
IF COL_LENGTH('[dbo].[cliente]', 'inativo') IS NULL
BEGIN
ALTER TABLE [dbo].[cliente] ADD inativo CHAR(1) NULL;
END
IF COL_LENGTH('[dbo].[cliente]', 'cri_data') IS NULL
BEGIN
ALTER TABLE [dbo].[cliente] ADD cri_data DATETIME2 NULL;
END
IF COL_LENGTH('[dbo].[cliente]', 'usuariocriacao') IS NULL
BEGIN
ALTER TABLE [dbo].[cliente] ADD usuariocriacao BIGINT NULL;
END
IF COL_LENGTH('[dbo].[cliente]', 'atu_data') IS NULL
BEGIN
ALTER TABLE [dbo].[cliente] ADD atu_data DATETIME2 NULL;
END
IF COL_LENGTH('[dbo].[cliente]', 'usuarioalteracao') IS NULL
BEGIN
ALTER TABLE [dbo].[cliente] ADD usuarioalteracao BIGINT NULL;
END
|
