Solved

Create index in access table

Posted on 2006-11-07
7
207 Views
Last Modified: 2010-04-05
Hello guys

How could I create an index in an  access table?

Something like this:

create index ....

thanks

0
Comment
Question by:hidrau
  • 4
  • 2
7 Comments
 
LVL 33

Expert Comment

by:hongjun
ID: 17889490
try this

CREATE UNIQUE INDEX IndexName ON TableName ([FieldName])
0
 
LVL 1

Author Comment

by:hidrau
ID: 17889715
this fieldname will have duplicated row. In access there is an option to allow or not duplicated rows, Mustn't I do this in the sql line?
0
 
LVL 33

Accepted Solution

by:
hongjun earned 300 total points
ID: 17889779
Do this

CREATE INDEX IndexName on TableName ([FieldName])


In this case, we are not specifying UNIQUE.
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 1

Author Comment

by:hidrau
ID: 17890525
ah i see
0
 
LVL 1

Author Comment

by:hidrau
ID: 17890613
I forgot to tell you that I need to check whether there is already an index created or not.

Do you have any Ideia how to do that?

0
 
LVL 25

Assisted Solution

by:Tomas Helgi Johannsson
Tomas Helgi Johannsson earned 200 total points
ID: 17896735
DROP INDEX IndexName;
COMMIT;
CREATE INDEX IndexName on TableName([FieldName];
COMMIT;

Regards,
  TOmas Helgi
0
 
LVL 1

Author Comment

by:hidrau
ID: 17897435
thanks very much
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to disable mouse scroll in a combo box field within a Delphi cxGrid 4 111
Delphi XE10 Round Image 2 79
Magic Software info 18 125
Adoquery sql  left join does not work 25 81
A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now