DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Primary key varchar(80)

  1. 10-10-2001, 08:25 PM #1
    Kumud
    Kumud is offline Member
    Join Date
    May 2000
    Location
    fremont ca
    Posts
    182
    Does the length of primary key matters ? what are the problems if we have primary key of so many characters.
    Reply With Quote Reply With Quote
  2. 10-10-2001, 08:40 PM #2
    sonofsita
    sonofsita is offline Member
    Join Date
    Sep 2001
    Location
    Fort Smith
    Posts
    184
    i do not see any problem as long as it is unique
    sonofsita
    http://www.ordba.net
    Reply With Quote Reply With Quote
  3. 10-10-2001, 09:05 PM #3
    grjohnson's Avatar
    grjohnson
    grjohnson is offline Senior Advisor
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    No It doesn't mater.. but it can be a little impractical. But it does depend on your data. I had a primary key of Varchar2(40). Because the unique key was made up of a combination on unix parameters that were generated and that is what the users wanted to be able to search on.

    Cheers,
    OCP 8i, 9i DBA
    Brisbane Australia
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width