blob: 1238ef13aa726b11d4837b2982e5c7de389b8f9b (
plain)
1
2
3
4
5
6
7
8
|
IF ((SELECT character_maximum_length FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'perfil' AND COLUMN_NAME = 'ceppernoite') <= 9 )
BEGIN
ALTER TABLE perfil ALTER COLUMN ceppernoite VARCHAR(10) NULL;
END
IF ((SELECT character_maximum_length FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'perfil' AND COLUMN_NAME = 'cepcirculacao') <= 9 )
BEGIN
ALTER TABLE perfil ALTER COLUMN cepcirculacao VARCHAR(10) NULL;
END
|
