Re: [firebird-support] How to change Primary Key on a table by adding a new field

2015-01-27 Thread Luigi Siciliano luigi...@tiscalinet.it [firebird-support]
ird-support@yahoogroups.com <mailto:firebird-support@ya%0Ahoogroups.com>] Sent: Monday, January 26, 2015 8:06 PM To: firebird-support@yahoogroups.com <mailto:firebird-support@yahoogroups.com> Subject: [firebird-support] How to change Primary Key on a table by adding a new field Hel

Re: [firebird-support] How to change Primary Key on a table by adding a new field

2015-01-26 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On Mon, 26 Jan 2015 19:05:33 +0100, "Luigi Siciliano luigi...@tiscalinet.it [firebird-support]" wrote: > Hello, >I have an application that use a Firebird database and I need to > change a Primary Key on a table by adding a new field. > > I can drop a primary key constraint by "ALTER TABLE M

RE: [firebird-support] How to change Primary Key on a table by adding a new field

2015-01-26 Thread 'Bogdan Mihalache' bogdan.mihala...@soter.ro [firebird-support]
to:firebird-support@yahoogroups.com> Subject: [firebird-support] How to change Primary Key on a table by adding a new field Hello, I have an application that use a Firebird database and I need to change a Primary Key on a table by adding a new field. I can drop a primary key constraint by &qu

RE: [firebird-support] How to change Primary Key on a table by adding a new field

2015-01-26 Thread 'Bogdan Mihalache' bogdan.mihala...@soter.ro [firebird-support]
rd-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Monday, January 26, 2015 8:06 PM To: firebird-support@yahoogroups.com Subject: [firebird-support] How to change Primary Key on a table by adding a new field Hello, I have an application that use a Firebird database and I need to

[firebird-support] How to change Primary Key on a table by adding a new field

2015-01-26 Thread Luigi Siciliano luigi...@tiscalinet.it [firebird-support]
Hello, I have an application that use a Firebird database and I need to change a Primary Key on a table by adding a new field. I can drop a primary key constraint by "ALTER TABLE MyTable DROP CONSTRAINT MyINTEG_000" where "MyINTEG_000" is the constraint on my development database file. I ca