DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Materialized View

  1. #1
    Join Date
    Jul 2001
    Posts
    93
    Hi,

    I have a materialized view on a table and if i add a new column to the base tables do i need to recreate the materialized view or will the newly added column gets populated in the materiaLized view automatically.


    Thanks

  2. #2
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    You have to recreate it.
    A View is a [b}View[/b] is a view

    It could have comprised of some columns of your table,
    all columns of your table or multiple columns from multiple tables. So if u want to add a column, you have to recreate it !

Posting Permissions

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


Click Here to Expand Forum to Full Width