Primary Key is an index?

[Guest]

When you create a primary key on a table, does the primary key create an index or is it just a constrinat on the table

Thanks
ThomasLL

 

[Allen Browne]

Open your table in design view.

Click the Indexes button on the toobar.

You will see that Access uses the name "PrimaryKey" for the index that is
the primary key.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

When you create a primary key on a table, does the primary key create an

index or is it just a constrinat on the table?

 

[Cheryl Fischer]

Yes; it creates an Index named PrimaryKey.

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX

When you create a primary key on a table, does the primary key create an

index or is it just a constrinat on the table?

 

[Tim Ferguson]

When you create a primary key on a table, does the primary key create
an index or is it just a constraint on the table?

Yes to both

Tim F

 

[John Vinson]

does the primary key create an index

Yes.

 

[Guest]

thanks