SAP Knowledge Base Article - Preview

3154205 - Alter table does not reflect new name on sys.sysidx - SAP IQ

Symptom

Alter table does not reflect new name on sys.sysidx.index_name for the Primary key index_category=1. It remains with the previous name. See:

=====

create table mytabla ( i int not null , j int not null , primary key (i ))

select i.* from sys.sysidx i,systab t where t.table_id= i.table_id and t.table_name='mytabla' ;
table_id index_id object_id phys_index_id dbspace_id index_category unique index_name not_enforced file_id
---------- ---------- -------------------- ------------- ---------- -------------- ------ ----------------------- ------------ -------
115565 0 47728329 NULL 16387 1 2 mytabla N 16387
115565 1 47728330 NULL 16387 3 4 ASIQ_IDX_T115565_C1_FP N 16387
115565 2 47728331 NULL 16387 3 4 ASIQ_IDX_T115565_C2_FP N 16387
115565 3 47728332 NULL 16387 3 2 ASIQ_IDX_T115565_I3_HG N 16387

alter table mytabla rename tuTabla ;

select i.* from sys.sysidx i,systab t where t.table_id= i.table_id and t.table_name='tutabla' ;
table_id index_id object_id phys_index_id dbspace_id index_category unique index_name not_enforced file_id
---------- ---------- -------------------- ------------- ---------- -------------- ------ ------------------------ ------------ -------
115565 0 47728329 NULL 16387 1 2 mytabla N 16387
115565 1 47728330 NULL 16387 3 4 ASIQ_IDX_T115565_C1_FP N 16387
115565 2 47728331 NULL 16387 3 4 ASIQ_IDX_T115565_C2_FP N 16387
115565 3 47728332 NULL 16387 3 2 ASIQ_IDX_T115565_I3_HG N 16387

=====


Read more...

Environment

SAP IQ 16.0 and higher

Product

SAP IQ 16.0

Keywords

rename index primary key sys.sysidx.index_name SYSIDX alter table alter index , KBA , BC-SYB-IQ , Sybase IQ , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.