And with the standard IB one. I think Ann gave me my answer. I had
been creating
the index then assigning the index as the primary key (as in Oracle).

I just tried it and when I check for primary Key I get it.

When I go to indexes, it has an index with the name "RDB$PRIMARY1"

Wouldn't it make sense to name the index to match the primary key name?

Martijn Tonies wrote:

>
>
>>TSQLMetaData.
>>
>>
>
>With the Firebird dbExpress driver? Man, that thing is soo flaky ... :)
>
>
>With regards,
>
>Martijn Tonies
>InterBase Workbench - the developer tool for InterBase
>http://www.upscene.com
>
>Firebird Workbench - the developer tool for Firebird
>http://www.upscene.com
>
>Upscene Productions
>http://www.upscene.com
>
>"This is an object-oriented system.
>If we change anything, the users object."
>
>
>
>>Martijn Tonies wrote:
>>
>>
>>
>>>Hi,
>>>
>>>
>>>
>>>
>>>
>>>>When I create a primary key, the engine makes two indexes. One as a
>>>>
>>>>
>>>>
>>>>
>>>primary
>>>
>>>
>>>
>>>
>>>>key and one that it not. They both are indecies of the primary key. Is
>>>>this a bug?
>>>>
>>>>
>>>>
>>>>
>>>It only creates one index at my place... What build are you running and
>>>what tool to view the metadata?
>>>
>>>
>>>With regards,
>>>
>>>Martijn Tonies
>>>InterBase Workbench - the developer tool for InterBase
>>>http://www.upscene.com
>>>
>>>Firebird Workbench - the developer tool for Firebird
>>>http://www.upscene.com
>>>
>>>Upscene Productions
>>>http://www.upscene.com
>>>
>>>"This is an object-oriented system.
>>>If we change anything, the users object."
>>>
>>>
>>>
>>>To unsubscribe from this group, send an email to:
>>>ib-support-unsubscribe@egroups.com
>>>
>>>
>>>
>>>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>--
>>Thomas Miller
>>Delphi Client/Server Certified Developer
>>BSS Accounting & Distribution Software
>>BSS Enterprise Accounting FrameWork
>>
>>http://www.bss-software.com
>>
>>
>>
>>[Non-text portions of this message have been removed]
>>
>>
>>
>>To unsubscribe from this group, send an email to:
>>ib-support-unsubscribe@egroups.com
>>
>>
>>
>>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>>
>>
>>
>>
>>
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>

--
Thomas Miller
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork

http://www.bss-software.com



[Non-text portions of this message have been removed]