[AccessD] Fw: [dba-OT] favor -- about index names

Susan Harkins wrote:

>  
>
>>CREATE TABLE States (State TEXT(15) PRIMARY KEY)
>>
>>
>>
>>Would someone please run this simple query in Access 2000 and Access 97
>>    
>>
>and
>  
>
>>then open the new table
>>
>>and tell me how Jet named the index? I don't have either installed
>>    
>>
>anymore.
>  
>
>>
>>Jet 4 (Access 2002) assigns an index value type name -- for example
>>Index_542C89A9_F5FE_4304 -- which I don't believe earlier
>>
>>versions of Jet did -- just checking because I don't remember.
>>
>>
>>
>>This looks new to me. Seems to me, Jet always used the field's name as the
>>index name.
>>    
>>

 In Access 2003 the index name is
     Index_5176FBB8_AEC2_42D4

In Access97  

CREATE TABLE States (State TEXT(15) PRIMARY KEY)

gives a syntax error, it will only compile if index named with 
constraint clause

CREATE TABLE States (State TEXT(15) constraint mykey  Primary Key)