>Hi!
>
> Let's me describe my problem:
> I have a DataDictionary.DBC which contains several tables, one of them is DataDict, which describes all fields in all my tables, another table is IndxDict, which describes indexes in all my tables. It has this structure:
>Table - Character (name of table)
>TagName - Character
>IndexExpr - Memo
>Type - Character (Primary, Regular, Candidate, etc.)
>Filter - Memo.
>
> As you can guess, this DataDictionary uses to generate our life DataBase with all tables and Indexes.
>
> I wrote a code for table generating, but have some problems with Indexes.
>
> In help I read:
>
> INDEX ON eExpression TO IDXFileName | TAG TagName [OF CDXFileName]
> [FOR lExpression]
> [COMPACT]
> [ASCENDING | DESCENDING]
> [UNIQUE | CANDIDATE]
> [ADDITIVE]
>
> I didn't see Primary or Regular here in this Syntax.
>
> Could you please help me with this? I mean, which command I need to use to create indexes using my IndxDict.
>
A Regular index is an index with no qualifier.
A primary key is nothing more than a CANDIDATE key established in the database container as a Primary key. It needs to be created and added to the table within the database container using the ALTER TABLE statement rather than the INDEX statement.