Hi,

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