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
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.
SAP Knowledge Base Article - Preview