Re: [ADMIN] dropping a table constraint

2004-09-13 Thread Lee Wu
ct: [ADMIN] dropping a table constraint   I needed to add a FK constraint to a table where one was forgotten. I found an add constraint command and used it: ALTER TABLE file_info add foreign key (al_fk) references arraylayout(al_pk); However, I wanted to name the constraint. It now looks like

[ADMIN] dropping a table constraint

2004-09-13 Thread Jodi Kanter
I needed to add a FK constraint to a table where one was forgotten. I found an add constraint command and used it: ALTER TABLE file_info add foreign key (al_fk) references arraylayout(al_pk); However, I wanted to name the constraint. It now looks like this: $1 FOREIGN KEY (al_fk) REFERENCES