I'm currently designing the schema of my database for an application. and there's this table that has a default content or records. i'm torn between what type should i use for its key, because im always using autonumber, i was thinking that because i have a default content for this table, might better to use a unique id instead so per database deployment, the id will always be the same for every installation. is that assumption valid?

Also, when should i use uniqueidentier over an autonumber for a primary key?


hey thanks for thinks griswolf!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.