I am writing a program that re-indexes the tables in a database. First, the program delete all the tags ("delete tag all"). Then it issues "index on xxx tag yyy [for zzz] [descending] [candidate]". This works fine unless the tag needs to be a primary key. The "index on..." command doesn't seem to have a way to specify that the tag is to be the primary key. The only solution I've found is to use the command "alter table aaa add primary key bbb...". The problem with this approach is that it doesn't allow one to specify "descending" or a filter expression.

How does one programmatically create a primary index tag that contains a filter or the "descending" clause?

Thanks,
Chris Lawrence