Chris Velevitch wrote:
But what about my original question?
"What is the point of the create or replace view command if you
can't change the
column and data types?"
-- create table t1
create table t1(f int);
-- create view v1 based on table t1
create view v1 as select * from t1;
-- create view v2 based on view v1
create view v2 as select * from v1;
-- attempt to drop and recreate view v1 with a WHERE clause
drop view v1;
-- attempt to create or replace view v1 with a WHERE clause
create or replace view v1 as select * from t1 where 1 = 1;
-- attempt to create or replace view v1 with a different WHERE clause
create or replace view v1 as select * from t1 where 1 = 2;
HTH,
Joe
