Question Using CREATE-LIKE without Indexes

[KMoody]

I have a dynamic temp-table that can be like any table the user enters. However, I don't want the temp-table to have any of the source table's indexes.

Here's my code:

DEFINE INPUT  PARAMETER tableName     AS char.
DEFINE VARIABLE ttxxMult            AS HANDLE.

CREATE TEMP-TABLE ttxxMult.
ttxxMult:CREATE-LIKE (tableName).

How can I remove the temp-table's indexes?

 

[GregTomkins]

Could you use ADD-FIELDS-FROM instead (with an empty 'except' list) ?

 

[tamhas]

Why do you want to get rid of the indexes?

 

[KMoody]

Yep, that did it. Thanks!

Tamhas, I want to join two tables together in a temp-table, but one of the tables has a unique index for one of its fields.

 

[tamhas]

Then the temp-table is not actually LIKE the DB table, is it?

Frankly, while LIKE seems convenient, I dislike its use, anywhere.

 

[Cringer]

Not sure if it applies in dynamic tt creation, but certainly when you statically define a tt like a table it inherits the indexes UNLESS you define a custom index, at which point it inherits none. So you could try adding a custom index and see if that helps.