Adding Item into Index

Toad Data Modeler
1

Hi all. I would like to create a script that for each column which is not a primary key, a bitmap index is created and that column is added as an Item into the Index.

2

Here is the example. I was unable to post the code into the forum because half of the code was removed.
example.js (832 Bytes)

3

Never mind, I sussed it out.

indexItem = NewIndex.CreateNewObject(2013);
indexItem.SetLinkedObject(“Attribute”, Attribute)

4

Great! Congratulations!

Vaclav