blob: a627e4cbf5e3cce349711384d4a78724b3331b4f (
plain)
1
2
3
4
5
6
7
|
IF EXISTS (SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'usuario' AND COLUMN_NAME = 'cgccpf')
BEGIN
IF ((SELECT CHARACTER_MAXIMUM_LENGTH FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'usuario' AND COLUMN_NAME = 'cgccpf') < 20)
BEGIN
ALTER TABLE usuario ALTER COLUMN cgccpf VARCHAR(20)
END
END
|
