Thanks for the answers. They really helped me.
As I thougth, that is sort of issue related
to modeling, design, RDBMS and experience!
Best regards,
Rafael Charnovscki
> Rafael Charnovscki <charnovs@unesc.rct-sc.br> writes:
>
>>I have a 6-digit integer number for a patient identifier which
>>I intend to use as a primary key (PK) for a table. It also will
>>be a foreign key in other tables. Do I have to use an integer data
>>type as a domain for this PK or could I use a varchar(6)?