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

Search for additional results

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