Re: Help with ALTER TABLE statement
- From: Marshall Barton <marshbarton@xxxxxxxxxx>
- Date: Wed, 15 Feb 2006 00:08:39 -0600
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?
Well I don't use it all that much either Allen, so I have to
look it up in Help every time I do ;-)
AFAIK, an allow duplicates index/constraint just doesn't
specify the UNIQUE option.
The way I undestand it Create Index is not quite a subset of
a Constraint clause. A constraint can also specify a
relationship with or without the Cascade options, but there
may be a difference that I am not aware of - thus my earlier
question.
Re our long standing issue with invisible, duplicate
indexes, I did dig into the relationship part of a
Constraint clause once in hopes of using an existing index
instead of having the relationship create a duplicate index,
but no, a relationship can not be specified unless a new
index is also specified :-(
Checking Help once again, I see that I will have to dig up
those old experiments and try again using A02/03 to see what
the new NO INDEX option does.
--
Marsh
MVP [MS Access]
.
- Follow-Ups:
- Re: Help with ALTER TABLE statement
- From: Robert Valentine
- Re: Help with ALTER TABLE statement
- References:
- Help with ALTER TABLE statement
- From: Robert Valentine
- Re: Help with ALTER TABLE statement
- From: Allen Browne
- Re: Help with ALTER TABLE statement
- From: Marshall Barton
- Re: Help with ALTER TABLE statement
- From: Allen Browne
- Help with ALTER TABLE statement
- Prev by Date: RE: Filtering data in an Array
- Next by Date: Re: Representing a null text field value in VBA
- Previous by thread: Re: Help with ALTER TABLE statement
- Next by thread: Re: Help with ALTER TABLE statement
- Index(es):
Relevant Pages
|
