G Guest Apr 1, 2004 #1 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
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
A Allen Browne Apr 1, 2004 #2 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. [email protected] said: When you create a primary key on a table, does the primary key create an Click to expand... index or is it just a constrinat on the table?
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. [email protected] said: When you create a primary key on a table, does the primary key create an Click to expand... index or is it just a constrinat on the table?
C Cheryl Fischer Apr 1, 2004 #3 Yes; it creates an Index named PrimaryKey. -- Cheryl Fischer, MVP Microsoft Access Law/Sys Associates, Houston, TX [email protected] said: When you create a primary key on a table, does the primary key create an Click to expand... index or is it just a constrinat on the table?
Yes; it creates an Index named PrimaryKey. -- Cheryl Fischer, MVP Microsoft Access Law/Sys Associates, Houston, TX [email protected] said: When you create a primary key on a table, does the primary key create an Click to expand... index or is it just a constrinat on the table?
T Tim Ferguson Apr 1, 2004 #4 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? Click to expand... Yes to both Tim F
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? Click to expand... Yes to both Tim F
