Symptom
1> sp_helpindex table_name
2> go
Object has the following indexes
index_name index_keys index_description index_max_rows_per_page index_fillfactor index_reservepagegap index_created index_local
---------- ------------------------------------------------------------------ ----------------- ----------------------- ---------------- -------------------- ------------------- ------------
index_name1 col1, col2 clustered, unique 0 0 0 NULL Global Index
index_name2 col2, col4 nonclustered 0 0 0 May 05 2018 16:04PM Global Index
(2 rows affected)
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 12.5
- SAP Adaptive Server Enterprise (ASE) 15.0
- SAP Adaptive Server Enterprise (ASE) 15.5
- SAP Adaptive Server Enterprise (ASE) 15.7
- SAP Adaptive Server Enterprise (ASE) 16.0
Product
Keywords
sp_helpindex, index_created, NULL, crdate, sysindexes , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
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.