Re: Create table LIKE another including Primary key...

How often do you give your constraints a name versus let the system
generate a name?
Why?

For example, you can do

CREATE TABLE ORDLINE...
constraint ordline_key primary key
constraint ordline_to_ordhead foreign key order_number references ordhead
order_number

or you can do it without naming the ordline_key constraint or the
ordline_to_ordhead constraint and just let the system come up with it's
own names.
I do not believe you can have two constraints with the same name in the
same schema. (Which must make duplication fun.)

I suppose "meaningful" names might help if you do some error trapping.
Like maybe check the status code on a write in RPG and echo back the
constraint name displayed.

Rob Berendt