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