>Is there a way to programmatically create a primary key on a table that includes a FOR clause? I have a table that is set up like that in the MODI STRU box, but I need a way to re-create it in code. The ALTER TABLE command doesn't accept it.

What's your code look like?

Here's an example:

  ALTER TABLE TEMP1 ;
    ADD PRIMARY KEY T1_PK ;
      FOR .NOT.EMPTY(T1_PK) ;
      TAG T1_PK