Primary key redifinition.

[aligahk06]

Dear All,


Could it be possible to find out primary key in a table and then redine the primary key .

Any help?

Rgds,
Aligahk0

[OBP]

Aligahk0, it would depend on what you mean by Redefine the key field. Do you mean create a New Key field or renumber the current keys?
I think it is possible, but it will fraught with problems if you have any Tables using the Key field for linking.

Is the current key field an Autonumber field?

[aligahk06]

Aligahk0, it would depend on what you mean by Redefine the key field. Do you mean create a New Key field or renumber the current keys?
I think it is possible, but it will fraught with problems if you have any Tables using the Key field for linking.

Is the current key field an Autonumber field?

Yes

[OBP]

Yes to which question,
Create a New Key?
Renumber the current keys?
Is the keyfield an Autonumber field?