SAP Knowledge Base Article - Preview

2727203 - Rename a functional index using sp_rename - ASE


Would like to know if calculated index/column/functional index can be renamed.

Following command fails:

  • sp_rename "tablename.sybfi6_1" sybfi4_1

Msg 17786, Level 16, State 1:
Server 'svr_name', Procedure 'sp_rename', Line 278:
Object name cannot be changed either because it does not exist in this database,
or you don't own it, or it is a system name.
(return status = 1)

  • sp_rename "tablename.sybfi6_1", sybfi4_1, "index"

Msg 17782, Level 16, State 1:
Server 'svr_name', Procedure 'sp_rename', Line 468:
You do not own a table, column or index of that name in the current database.
(return status = 1)



SAP Adaptive Server Enterprise (All Versions)


Sybase Adaptive Server Enterprise 15.0


rename, function-based, index , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.