Access/SQL tables using text data type as a primary key
In Access/SQL tables how advisable is it to use text data type as a primary key.
I am building a database specifically for manufacturing where Part numbers and Customer Codes
, both text fields, need to be stored as the primary key. Is this advisable?
At the moment the tables are in Access but will in future be moved to a cloud SQL database.
I am building a database specifically for manufacturing where Part numbers and Customer Codes
, both text fields, need to be stored as the primary key. Is this advisable?
At the moment the tables are in Access but will in future be moved to a cloud SQL database.
Are the Part Nos and Customer Codes unique?
ASKER
Hi Norie. yes they are
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you all very much