Viacheslav N Tararin <[EMAIL PROTECTED]> writes:
> Why alter table commands not check index existence?
What do you want them to do exactly? Error out if there's an equivalent
index in place already? Absorb the index as the implementation of the
constraint? I don't really like either of those ..
Hi.
--- Next sequence of commans: ---
CREATE TABLE CURRENCY.CURRENCY (
ID integer NOT NULL,
CODE varchar(17) NOT NULL,
DESCRIPTION text,
PRINT_SYMBOL VARCHAR(17) NOT NULL,
VERSION smallint
);
create unique index PK_CURRENC