View Full Version : Primary key redifinition.
aligahk06
04-05-2010, 11:57 PM
Dear All,
Could it be possible to find out primary key in a table and then redine the primary key .
Any help?
Rgds,
Aligahk0
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
04-06-2010, 03:14 AM
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
Yes to which question,
Create a New Key?
Renumber the current keys?
Is the keyfield an Autonumber field?
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.