1. Martin Mueller
  2. PowerBuilder
  3. Thursday, 23 April 2020 18:23 PM UTC
Hi all,

our app is now almost 20 years old and many customers have improvised in the
database to achieve more performance.

With the next update we want to bring all customer databases to a common stand.
For this we want to read out and delete all indexes from an ASA 11 and replace
them with a uniform index structure. How can I read the indexes from a database in Powerbuilder to delete them? I appreciate every suggestion

best regards
Martin
Roland Smith Accepted Answer Pending Moderation
  1. Thursday, 23 April 2020 19:28 PM UTC
  2. PowerBuilder
  3. # 1

There is a system view: dbo.sysindexes

You could create a datawindow to retrieve the view. Then in a loop get the index name and build a drop command in a string and do an execute immediate.

The userid you log in as would need the proper security.

 

Comment
There are no comments made yet.
Martin Mueller Accepted Answer Pending Moderation
  1. Friday, 24 April 2020 03:56 AM UTC
  2. PowerBuilder
  3. # 2

Thanks Roland, it works fine

 

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.