Tag Archives: db2 index

Reverse engineer indexes in DB2 – Take 2

Last week, I posted my first version of the sql. I am expanding on that this week. The one last week, may not work in the coming db2 versions. This version uses the new table indexcoluse table to get the … Continue reading

Posted in db2 | Tagged , , | Leave a comment

Reverse engineer indexes in DB2 – Take 1

I love DB2LOOK for many reasons. Its a wonderful and easy way to reverse engineer a database. DB2LOOK can generate DDLs for specific table(s), but what if we just want indexes to be reverse engineered, thats were db2look hits the … Continue reading

Posted in db2 | Tagged , , , | Leave a comment