title: Do views get updated automatically after a DDL change on the underlying table?
body: <p>I am new to teradata and SQL in general.</p>
  
  <p>Let's assume I have a table SCHOOL with columns: id, name, role. And a view is built on top of this table as:</p>
  
  <p>CREATE OR REPLACE VIEW TEACHER AS SELECT * FROM SCHOOL WHERE ROLE = 'TEACHER';</p>
  
  <p>I now add a new column to SCHOOL, say subject_name. Do I need to re-execute the CREATE OR REPLACE VIEW statement so that TEACHER starts picking up this new column, or is it dynamic and adding the column will automatically result in the view picking up the new column the next time it is invoked.</p>