does mysql supports in the create_definition of the create table sintax the CHECK
sintax???
example:
Create table cliente (
idcliente Int(8) NOT NULL,
nombre Varchar(30) NOT NULL,
idzona Int(5) NOT NULL,
zipcode Varchar(8),
direccion Varchar(30) NOT NULL,
idasiscom Int(5) NOT NULL,
listaprecio Int(2) NOT NULL,
diasvencimientofactura Int(2) NOT NULL,
iva Char(1) NOT NULL Check (S, s, N, n, I, i ),
idmonedafacturacion Int(3) NOT NULL,
controltopecredito Int(1),
topecredito Decimal(9,2),
estadoregistro Char(1) NOT NULL Check (P, A, I ),
estadodescripcion Varchar(30),
fechaalta Date NOT NULL,
idusuario Int(5) NOT NULL,
Primary Key (idcliente)
) ;
Pablo Fraga (MIS).
e-mail:
[EMAIL PROTECTED]
[EMAIL PROTECTED]
