blob: 56600f1def104fe0e0f06cfd164a0b64a5fa4add (
plain)
1
2
3
4
5
6
7
8
9
|
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'clitelefone') AND COL_LENGTH('[dbo].[clitelefone]', 'fone') IS NOT NULL
BEGIN
ALTER TABLE [dbo].[clitelefone] ALTER COLUMN fone VARCHAR(20) NULL;
END
IF EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'clicontato') AND COL_LENGTH('[dbo].[clicontato]', 'fone') IS NOT NULL
BEGIN
ALTER TABLE [dbo].[clicontato] ALTER COLUMN fone VARCHAR(20) NULL;
END
|
