>> >> > 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.

So the answer is YES. Now, did you create this table
WITH THE PRIMARY KEY INFORMATION?

> The insert command should create the employee_2008_11.

"should create"? No it shouldn't, not in Firebird SQL.

> I have read this as a trick in google for a while.
> It seems to be the wrong way.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com