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 ONE Support launchpad (Login required).

Search for additional results

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