Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved index list of a asa database

  1. How-to
0
Votes
Undo
  1. Martin Mueller
    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
Cliente oracle recomendado para appeon 2019R2
PowerBuilder 2019 Composit DW Autosize Control Iss...
Responses (2)
Martin Mueller
Martin Mueller Accepted Answer Pending Moderation
  1. Friday, 24 April 2020 03:56 AM UTC
  2. PowerBuilder
  3. # 1

Thanks Roland, it works fine

 

Comment
There are no comments made yet.
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Thursday, 23 April 2020 19:28 PM UTC
  2. PowerBuilder
  3. # 2

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.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.