Subject Re: [firebird-support] Re: insert into with primary key
Author Martijn Tonies

>> >I copy a table with
>> >
>> > insert into newtable select * from oldtable
>> >
>> > The oldtable has a primary key. The newtable not.
>> >
>> > With kind regards
>> > Alfred
>> What's the question?
> the newtable lost the information which is the field with
> the primary key.
> I have always to set the primary key to the field manual.
> If I forgot, I got trouble with the update of the newtable.

But you created "newtable", didn't you?

So, did you create it with a primary key?

You're not telling us much - start with your exact steps,
and describe closely what the problem actually is.

With regards,

Martijn Tonies
Upscene Productions

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

Database questions? Check the forum: