This Will not execute (syntax error). Tried it allready.
Thnx anyway...
>Try ALTER TABLE TableName ADD PRIMARY KEY uPrimaryKeyExpression TAG PrimaryKeyTag FOR NOT Deleted()
>
>HTH
>
>>Is it possible to do something like alter table or so, to create a primary index With a filter clause???
>>
>>I know this can be done with candidate indexes, but I don't know how to switch a candidate to primary.
>>
>>The filter clause is : !deleted()
---
Life is like a box of chocolates