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.