> Is it there a sentence that lets me delete all the contents of a given

index in my database or at least recompute the index contents. I prefer
delete all if contents if I can. I only want to delete its contents not the
index itself

>

What do you mean by "delete the contents of an index"? What
would the effect be?

Indices are constantly updated whenever you insert/update or
delete data from the table.

What is it that you're trying to accomplish?

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com