Community

DB2 Administrative SQL Cookbook: Identifying Dependent MQTs and Views

(Ember Crooks) When you’re considering dropping and re-creating a table, view, or MQT, it is critical to ensure that you consider any dependencies. When dropping a table, any MQTs that rely on it will be dropped, and views marked inoperative.

Read More - Register for Free Membership

Tags: