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

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

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