Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Redefining a secondary index in SQL
Mon, Feb 9 2009 9:27 PMPermanent Link

Roland
Hi,

DBISAM Ver 4

I know how to redefine a primary index in SQL with the alter table statement but how do I redefine a secondary index.

Roland
Tue, Feb 10 2009 3:59 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Roland


DROP INDEX IF EXISTS table.index
CREATE INDEX IF NOT EXISTS "indexname" ON "table" (indexfields)

Roy Lambert [Team Elevate]
Image