
/*------ ATD 342460 ------*/
IF EXISTS (SELECT 1 FROM SYSCOLUMNS C JOIN SYSOBJECTS T ON C.ID = T.ID AND T.XTYPE = 'U'
				WHERE T.NAME = 'PEDICLICOMPLEMENTO' AND C.NAME = 'NUMPEDECOMMERCE' AND C.LENGTH < 100)
	ALTER TABLE PEDICLICOMPLEMENTO ALTER COLUMN NUMPEDECOMMERCE VARCHAR(100) NULL
go
IF EXISTS (SELECT 1 FROM SYSCOLUMNS C JOIN SYSOBJECTS T ON C.ID = T.ID AND T.XTYPE = 'U'
				WHERE T.NAME = 'PEDIDO_ECOMMERCE' AND C.NAME = 'NUMPEDECOMMERCE' AND C.LENGTH < 100)
	ALTER TABLE PEDIDO_ECOMMERCE ALTER COLUMN NUMPEDECOMMERCE VARCHAR(100) NOT NULL
go