| Subject | how to define another primary key in the table? |
|---|---|
| Author | d_dude_2003 |
| Post date | 2008-01-03T11:30:03Z |
I have a table with ID field defined as PK. ID is integer, i have a
generator, and putting a value for ID manually from the client
application.
Now i need to create another field, ID2 to be a PK in the table.
I also need to auto create generator and trigger to populate this field.
How do i remove a PK-mark from "ID" field and populate ID2 field for
existing rows?
Thanx alot.
generator, and putting a value for ID manually from the client
application.
Now i need to create another field, ID2 to be a PK in the table.
I also need to auto create generator and trigger to populate this field.
How do i remove a PK-mark from "ID" field and populate ID2 field for
existing rows?
Thanx alot.