Archives of the TeradataForum

Message Posted: Thu, 14 Nov 2002 @ 17:09:12 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

I do not find creating any index that much of a problem from ERwin. You can create a UPI, NUPI, USI, and NUSI all by using the index applet (right click on a table and pick 'indexes')

Once you specify with the check box either

1) check unique and check primary for UPI ----> Erwin creates an alternate key (AK)
2) un-check unique , chech primary for NUPI ----> Erwin creates an Inversion entry (IE)
3) check unique, un-check primary for USI ----> Erwin creates an alternate key (AK)
4) un-check unique, un-check primary for NUSI ----> Erwin creates an Inversion entry (IE)

Give each index an appropriate name such as NUSI_tableA. After identfying the appropriate 'member' columns, save and quit applet.

In order to generate these indexes as part of the ddl (Forward Engineer) generate step, you have to engage and edit the schema generation applet. Under Tool , Forward Engineer, you will see a default summary schema, make sure Teradata 2.x Target platform was previouly selected. Click the radio button for 'Edit Options'; In the Options window, scroll down to the "Index features. Make sure Alternate Key (AK), Inversion Entry (IE) and PRIMARY are all checked!

If you do a 'preview' you will see each non-primary index added immediatly after the table create statement...

Good Luck...

	<Prev	Next>		<<First	<Prev	Next>	Last>>