Delete status of DB2 Views

kespra · New User Joined: 03 Jun 2008 Posts: 24 Location: bangalore

If Master table gets deleted then view also will be deleted or not?

Suresh Ponnusamy · Posted: Fri Aug 15, 2008 9:29 pm Post subject:

Hi

If the Master Table is deleted, then VIEW definition will not be deleted but when you try to access the view, you will get -206 error code stating that the object is not found.

kespra · New User Joined: 03 Jun 2008 Posts: 24 Location: bangalore

Thanks for for the answer but one doubt whether View table is present or not

Suresh Ponnusamy · Posted: Fri Aug 15, 2008 11:28 pm Post subject:

View is not a physical stuff. It is a logical one. A view is an alternative way of representing data that exists in one or more tables.

No records will be stored inside the view. Whenever we access the view, it will in turn read the table based on the View definition and display the data.

Only the definition will be present. Logically speaking VIEW will not be present in other words, we cannot access if the base table is dropped.

Please refer the below link

http://msdn.microsoft.com/en-us/library/aa258841(SQL.80).aspx

Hope this helps.

wanderer · Posted: Sat Aug 16, 2008 6:03 am Post subject:

Suresh Ponnusamy · Posted: Tue Aug 19, 2008 7:53 pm Post subject:

Hi

View will not be automatically dropped when we drop the table. Yes, we cannot perform any operations using Views without the table existence but View definition will be reside in SYSIBM.SYSVIEWS until it expliciltly dropped.

wanderer · Posted: Thu Aug 21, 2008 1:22 am Post subject: