blob: 2cd86f28da322c9f91375da3c13f79ca23b4731e (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
IF COL_LENGTH('[dbo].[clitelefone]', 'padrao') IS NULL
BEGIN
ALTER TABLE [dbo].[clitelefone] ADD padrao CHAR(1) NULL;
END
IF COL_LENGTH('[dbo].[clitelefone]', 'operadora') IS NULL
BEGIN
ALTER TABLE [dbo].[clitelefone] ADD operadora NUMERIC(5,0) NULL;
END
IF COL_LENGTH('[dbo].[clitelefone]', 'ramal') IS NULL
BEGIN
ALTER TABLE [dbo].[clitelefone] ADD ramal VARCHAR(5) NULL;
END
|
