ALTER TABLE VEHICULOS ADD VEH_GPS VARCHAR(250),VEH_GPU VARCHAR(50),VEH_GPC VARCHAR(50)
GO
CREATE TABLE TIPOSCOMNIIF ( 
TIP_COD VARCHAR(3) NOT NULL,
TIP_CIA CHAR(2) NOT NULL,
TIP_CLA VARCHAR(10) NOT NULL,
TIP_TCN VARCHAR(3) NOT NULL
 CONSTRAINT PK_TIPOSCOMNIIF PRIMARY KEY CLUSTERED (TIP_COD,TIP_CIA,TIP_CLA),
 CONSTRAINT CK_TIPOSCOMNIIFTIP_CIA CHECK ((len([TIP_CIA])>(0))),
 CONSTRAINT CK_TIPOSCOMNIIFTIP_CLA CHECK ((len([TIP_CLA])>(0))),
 CONSTRAINT CK_TIPOSCOMNIIFTIP_COD CHECK ((len([TIP_COD])>(0))),
 CONSTRAINT CK_TIPOSCOMNIIFTIP_TCN CHECK ((len([TIP_TCN])>(0))))
GO