listing expressions used (lstexp)

[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

[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.