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.
What I am trying to do is write some SQL that runs nightly to script all the indexes out.
Comment