whene i first encountered the problem i look in the help file and tried those examples.
then I went ot google and found the sad truth that what I wanted to do cant be done
I guess SQLserve doent have regulat indexes without a reference :-(

Peter




>Peter, just start with the example from CREATE TABLE
>

>CREATE TABLE Customer ;
>   (SalesID c(6), ;
>   CustId i PRIMARY KEY, ;
>   CustName c(20) UNIQUE,   ;
>   SalesBranch c(3), ;
>   FOREIGN KEY SalesId TAG SalesId REFERENCES Salesman)
>

>
>This works
>
>Lutz
>>how do you create a regular indx (without relation to another table) in a create table statement
>>

>>tname=[JFUNDS]
>>
>>
>>CREATE TABLE ([data\]+tname) (;
>>	id i PRIMARY KEY default sp_default("ID","JFUNDS"),;
>>	fundname c(20) FOREIGN KEY UPPER(fundname) TAG fundname,;    <<------- syntax error on this line
>>	status c(10) FOREIGN KEY UPPER(status) TAG status,;
>>	Notes  m,;
>>	insdttm T DEFAULT sp_default("DATETIME"),;
>>	insuser_id I DEFAULT sp_default("USERID"),;	
>>	upddttm T DEFAULT sp_default("DATETIME"),;
>>	upduser_id I DEFAULT sp_default("USERID") ;
>>	  )
>>
>>

>>
>>thanks
>>
>>Peter