ALTER TABLE TIPOSCAR ADD CAR_SCT VARCHAR(10)
GO 
CREATE TABLE FACTORESSAN ( 
FAC_NUM INT DEFAULT ((0)) NOT NULL,
FAC_FEC SMALLDATETIME NOT NULL,
FAC_TIP VARCHAR(10) NOT NULL,
FAC_SML MONEY DEFAULT ((0)) NOT NULL,
FAC_VAL DECIMAL(14,4) DEFAULT ((0)) NOT NULL,
FAC_INI SMALLDATETIME NOT NULL,
FAC_FIN SMALLDATETIME,
FAC_USU VARCHAR(8) NOT NULL,
FAC_HOR SMALLDATETIME NOT NULL
 CONSTRAINT PK_FACTORESSAN PRIMARY KEY CLUSTERED (FAC_NUM),
 CONSTRAINT CK_FACTORESSANFAC_TIP CHECK ((len([FAC_TIP])>(0))),
 CONSTRAINT CK_FACTORESSANFAC_USU CHECK ((len([FAC_USU])>(0))))
GO