From a SQL POV an index is only usefull for relationships and primary/candidate. Nobody would sort / filter data with an index. Thats outdated a bit. I use them for RUSHMORE only (and that's a relationship in most cases)

Lutz


>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