Solved

Create index in access table

Posted on 2006-11-07
7
206 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
Comment Utility
try this

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

Author Comment

by:hidrau
Comment Utility
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
Comment Utility
Do this

CREATE INDEX IndexName on TableName ([FieldName])


In this case, we are not specifying UNIQUE.
0
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 
LVL 1

Author Comment

by:hidrau
Comment Utility
ah i see
0
 
LVL 1

Author Comment

by:hidrau
Comment Utility
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 24

Assisted Solution

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

Regards,
  TOmas Helgi
0
 
LVL 1

Author Comment

by:hidrau
Comment Utility
thanks very much
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
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…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

772 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

14 Experts available now in Live!

Get 1:1 Help Now