Board index » delphi » Creating Primary Key on existing Interbase table

Mark G

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Creating Primary Key on existing Interbase table

Is there a way to create a Primary Key on an existing interbase table?
 
Steve Koters

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Creating Primary Key on existing Interbase table


Quote
On Tue, 13 Apr 1999 14:48:23 -0500, "Mark G" <Mark...@aol.com> wrote:
>Is there a way to create a Primary Key on an existing interbase table?

Take a look at the ALTER TABLE statement. The Language Reference
manual for this statement lists constraints as a type of metadata
object that can be added using ALTER TABLE. PRIMARY KEY is a type of
constraint and is listed there.

//////////////////////////////////////////////////////////////////////////
Steve Koterski                  "The income tax has made liars out of more
Technical Publications          Americans than golf."
Borland                                         -- Will Rogers (1879-1964)
http://www.borland.com/delphi

Dan Palle

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Creating Primary Key on existing Interbase table


Try:

    Alter Table TABLE_NAME Add Constraint CONSTRAINT_NAME Primary Key
(FIELD_NAME)

Regards,

Dan Palley
TRAMS, Inc.

Quote
Mark G <Mark...@aol.com> wrote in message

news:7f06gr$ejl2@forums.borland.com...
Quote
> Is there a way to create a Primary Key on an existing interbase table?

Sali

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Creating Primary Key on existing Interbase table


Hi,

Just wanted to add this. If the field is not null, then there is no way
other than to create another non-null field before adding the primary key.

(OR DO WE?)

Salim

Quote
Steve Koterski wrote in message <3713c91a.21037...@forums.inprise.com>...
>On Tue, 13 Apr 1999 14:48:23 -0500, "Mark G" <Mark...@aol.com> wrote:

>>Is there a way to create a Primary Key on an existing interbase table?

>Take a look at the ALTER TABLE statement. The Language Reference
>manual for this statement lists constraints as a type of metadata
>object that can be added using ALTER TABLE. PRIMARY KEY is a type of
>constraint and is listed there.

>//////////////////////////////////////////////////////////////////////////
>Steve Koterski                  "The income tax has made liars out of more
>Technical Publications          Americans than golf."
>Borland                                         -- Will Rogers (1879-1964)
>http://www.borland.com/delphi

Other Threads

1. Primary key when creating Interbase table

2. add a primary key to existing table

3. Creating primary index on existing tables

4. Interbase - Can't add primary key to table

5. Create Access Tables with Primary Keys

6. primary key on create table?

7. Modifing primary key after table created

8. Creating primary key for Access 97 tables

9. Number out of range error on Pdox table create w/autoinc primary key

10. Primary key or not primary key.........