--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@...> wrote:

>
>
> >> > insert into employee_2008_11 select * from employee_2008
> >> >
> >> > and employee_2008_11 lost the information of the primary key.
> >>
> >> What does this mean? Did it lose -metadata- information about
> >> which columns are part of the primary key?
> > Yes.
>
> But you yourself created table "employee_2008_11", didn't you?
> How did you create it?

I created employee_2008 for myself.

The insert command should create the employee_2008_11.
I have read this as a trick in google for a while.
It seems to be the wrong way.

>
> >> Or do the primary key -values- change when you do the INSERT?
> > No. The values are all correct.
> >>
>

With regards
Alfred Langer