I have hundreds of indexes and I need to define the tablespace for them. Do I need to do it manually, one by one? No 🙂

 

First define the tablespace you want to set for the indexes:

Then select one of the indexes and set the Tablespace Property:

Press Apply.

Press Propagate Properties.

In the Properties section press Deselect All. Select Tablespace.

In the Object section press Select All.

Press OK.

 

Now the tablespace for all indexes has been set as Index_Tablespace1.

 

 

 

 

I want to define an identity column and set the Auto Increment properties. How can I do that?

This definition can be made in the relational model. Select the primary key column and go to the Column Properties (the XYZ and a pen icon).

In General tab select Indentity Column and Auto Increment.

Then select the Auto Increment tab:

And set the properties as wanted.

Now if you generate the DDL this is what you get: