CREATE TABLE NIIFTASAS ( TAS_ID INT IDENTITY ( 1,1 ) NOT NULL, TAS_TIP VARCHAR(3) DEFAULT ('CXC') NOT NULL, TAS_INI DECIMAL(14,4) DEFAULT ((0)) NOT NULL, TAS_FIN DECIMAL(14,4) DEFAULT ((0)) NOT NULL, TAS_COD VARCHAR(3) NOT NULL CONSTRAINT PK_NIIFTASAS PRIMARY KEY CLUSTERED (TAS_ID), CONSTRAINT CK_NIIFTASASTAS_COD CHECK ((len([TAS_COD])>(0))), CONSTRAINT CK_NIIFTASASTAS_TIP CHECK ((len([TAS_TIP])>(0)))) GO