Re: Help with ALTER TABLE statement

Allen Browne wrote:

Marsh, I don't use DDL much, so I'm not sure how to add a CONSTRAINT that
will index the field "Duplicates Ok." Is that a constraint?


Allen,
Well, I was at least partially wrong about this whole issue.
While it's true that leaving out UNIQUE will deal with the
Duplicates OK issue, the NOT NULL option must then be
specified. This does not meet Bob's needs so that's the
reason he needs to use the CREATE INDEX statement.

There are more differences between CONSTRAINT and CREATE
INDEX than I had realized.

Sorry about all the confusion I brought to the thread.

--
Marsh
MVP [MS Access]
.

Relevant Pages

  • Re: general Q about formulae
    ... >>combination of two fields (sampleID and testname). ... >>these two fields and then made that an index field (no duplicates)? ... > easy define a PRIMARY KEY or UNIQUE constraint on a combination of two ...
    (comp.databases.ms-sqlserver)
  • Re: general Q about formulae
    ... >combination of two fields (sampleID and testname). ... >these two fields and then made that an index field (no duplicates)? ... ADD CONSTRAINT NoDuplicates UNIQUE ...
    (comp.databases.ms-sqlserver)
  • Re: Help with ALTER TABLE statement
    ... Allen Browne wrote: ... Is that a constraint? ... an allow duplicates index/constraint just doesn't ... specify the UNIQUE option. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Help with ALTER TABLE statement
    ... Is that a constraint? ... an allow duplicates index/constraint just doesn't ... specify the UNIQUE option. ... I see that I will have to dig up ...
    (microsoft.public.access.modulesdaovba)
  • Re: Check table for like values
    ... Allen Browne - Microsoft MVP. ... am looking for a way to find more than just duplicates. ... FROM tblImported INNER JOIN tblContacts ... Dim strSql As String ...
    (microsoft.public.access.modulesdaovba)