<< Any view defined as with an asterisk will be corrupted by a change to the number of columns or their data types in an underlying table:
CREATE VIEW mySubsetView AS SELECT * from tablename WHERE whatever >> I believe this was fixed several versions ago. I now find that SELECT * views can survive the addition of columns to the underlying tables. -- Larry
