Results 1 to 2 of 2

Thread: DB2 question - views

  1. #1
    Join Date
    Mar 2007
    Posts
    1

    DB2 question - views

    View, as it well known, is basically a SELECT, applied on a physical table or another view (nested).
    I have 2 questions.

    1. Where is view stored? I mean the view definition itself. Like for example table info is in SYIBM.SYSTABLE etc.

    2. If I drop a table, which has views, what will happen with the views? Will they be

    a. deleted automatically?

    b. stay in the system and return an error when somebody try to use them?

    c. drop will be aborted with the message that I have to drop all related views first?

    Many thanks to the one, who answers.

  2. #2
    Join Date
    Apr 2007
    Posts
    2
    Hi,

    View definition will be stored in SYSIBM.VIEW ayatem table.

    If you drop a table the related view will not be dropped automatically.

    It will be marked inoperatable.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •