Modifing primary key after table created

Dan Palley

Delphi Developer

Sun, 26 Sep 2004 23:20:38 GMT

Modifing primary key after table created

You would need to drop the primary key constraint, add the field, and
recreate the primary key constraint.

Dan

Quote

"Ryan McGinty" <rmcgi...@oceris.com> wrote in message

news:3cb457b6$1_2@dnews...

Quote

> Is there any way in SQL to modify the primary key for an existing table?
> Specifically, I need to add a field to the table and add that field to the
> fields that make up the primary key. Thanks in advance!

> Ryan McGinty

Ryan McGint

Delphi Developer

Sun, 26 Sep 2004 23:25:47 GMT

Re:Modifing primary key after table created

Is there any way in SQL to modify the primary key for an existing table?
Specifically, I need to add a field to the table and add that field to the
fields that make up the primary key. Thanks in advance!

Ryan McGinty

Other Threads

1. Primary key when creating Interbase table

2. Create Access Tables with Primary Keys

3. primary key on create table?

4. Creating Primary Key on existing Interbase table

5. Creating primary key for Access 97 tables

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

7. Primary key or not primary key.........

8. Create primary key dynamic using SQL (I use access databas)

9. Newbie: Create primary key with ADOX

10. ADOX, Creating a Primary Key for Access 2000 DB