You can rename an index in a base table or global temporary table with the owner type USER. See the ALTER INDEX command in the Sybase IQ Reference Manual for more information on renaming indexes and changing foreign key role names. Note that indexes created to enforce key constraints cannot be renamed.