CREATE TABLE DBO.ARTICULOS (
IDARTICULO INT NOT NULL,
IDEMP INT NOT NULL,
TIPO CHAR(1) NULL,
DESCRIPCION CHAR(500) NULL,
COSTOU MONEY NULL,
MAXIMO INT NULL,
MINIMO INT NULL,
BLOQUEADO CHAR(1) NULL,
IDUSR CHAR(10) NULL,
CONSTRAINT PK_ARTICULOS PRIMARY KEY (IDARTICULO, IDEMP),
CONSTRAINT CKT_ARTICULOS CHECK (TIPO = IN('P','S','C')
BLOQUEADO IN('S','N'))
)
go