Page 1 of 1

listing expressions used (lstexp)

Posted: Fri Jun 22, 2007 1:21 pm
by basement_addict
regarding this statement:

"If you update an index it will use the expressions that were in force when initially created."


How would I go about getting the expressions that were used when the index was initially created?


Thanks

listing expressions used (lstexp)

Posted: Fri Jun 22, 2007 2:12 pm
by mark
Unfortunately there's no direct way to do it. You could addtable the _P.tbl file for the index and select * from that where Param='Index Expression'. Or, on *nix you could run "strings" on the _P.tbl file.