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