Re: Is AutoIncrement recommended or not?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

"Dmitriy Antonov" <antonovdima@xxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:evDjFqr9FHA.472@xxxxxxxxxxxxxxxxxxxxxxx
>
> "MP" <nospam@xxxxxxxxxx> wrote in message
> news:nGHjf.431$1U2.303@xxxxxxxxxxxxxxxxxxxxxxxx

> > Seems I've seen some references to AutoIncrementing columns being bad
idea
snip
> > What's the consensus here?

>
> I am not aware of issues related to autonumbering, while some specific
> definitely exists. For example, you should take it in account, when you
> construct Update and Insert queries.
> snip

> Again, whether to use Autoincrement or use your own numbering strategy -
it
> is more matter of personal preferences or given specifications. What I am
> saying is simple: Primary Key should not have other meaning than
uniqueness
> and it is better to use numeric value for it. Autonumbering is just simple
> and convenient way to meet these requirements.
>
> There may be other opinions on subject.
>
> Dmitriy.
>

Thank you somuch for your answer.

May I trouble you with another question?

In reference to your phrases "Relationships, Parents, and Children"

> If you create Relationships
> (ref.keys), then, depending on settings on those Relationships, it will
> either not let you to delete a parent record (error raised) or it will
> delete all children

at this beginning point of my learning I think that means:

I create a Relationship when I make PrimaryKey of TableTwo a ForeignKey of
TableOne
is that correct?

In that case then TableOne becomes Parent and TableTwo becomes Child
is that correct?

thank you again
Mark


.

Relevant Pages

  • Re: Origins of Varsity match players 2011
    ... speaking with an English accent when being recorded but an ... I can find other references if you don't like Wikipedia, ... I doubt that a "chummy" interview with one of Surrey's P.R. people (or ...
    (uk.sport.cricket)
  • Re: A list of cities going farther and farther back into antiquity
    ... that I deal with literary evidence. ... you can do to stop my posting. ... references that don't show any real understanding of the issues ...
    (sci.archaeology)
  • Re: Access to Mainframes via Putty?
    ... in the post you referenced but your "snip" ignored it. ... The references are as follows: ... IBM Communications Server for OS/390 TCP/IP 2000 Update ... it may be the same port but you'll be required to use a different ...
    (bit.listserv.ibm-main)
  • Re: OB Truck Driving
    ... References within these are given ... <snip the rest of Candlish's trolling> ... So why can't you cite them?! ... Since your post is obviously just another of your sick little trolling ...
    (uk.tech.broadcast)
  • Re: RosAsm?[OT#2]
    ... [SNIP] ... aren't women naturally providing references when they gossip? ... above the "3" on my keyboard is ... I do manage to hit the "Q" key with the other pinky. ...
    (alt.lang.asm)