ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Script Indexes

Collapse
This topic is closed.
X
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Script Indexes

    Are there any system tables that contain the columns that compose an index. I see the sysindexes table so I have the index name but no idea what columns make up the index.

    What I am trying to do is write some SQL that runs nightly to script all the indexes out.

  • #2
    Re: Script Indexes

    Look for SysPartitionIndexes
    Patrick

    Comment


    • #3
      Re: Script Indexes

      Great Thanks

      Comment

      Working...
      X