Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 217
  • Last Modified:

Create index in access table

Hello guys

How could I create an index in an  access table?

Something like this:

create index ....

thanks

0
hidrau
Asked:
hidrau
  • 4
  • 2
2 Solutions
 
hongjunCommented:
try this

CREATE UNIQUE INDEX IndexName ON TableName ([FieldName])
0
 
hidrauAuthor Commented:
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
 
hongjunCommented:
Do this

CREATE INDEX IndexName on TableName ([FieldName])


In this case, we are not specifying UNIQUE.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
hidrauAuthor Commented:
ah i see
0
 
hidrauAuthor Commented:
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
 
Tomas Helgi JohannssonCommented:
DROP INDEX IndexName;
COMMIT;
CREATE INDEX IndexName on TableName([FieldName];
COMMIT;

Regards,
  TOmas Helgi
0
 
hidrauAuthor Commented:
thanks very much
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now