SAP Knowledge Base Article - Preview

2727203 - Rename a functional index using sp_rename - ASE

Symptom

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

Following command fails:

  • sp_rename "tablename.sybfi6_1" sybfi4_1
    go

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"
    go


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)


Read more...

Environment

SAP Adaptive Server Enterprise (All Versions)

Product

Sybase Adaptive Server Enterprise 15.0

Keywords

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.