How do you add a column to a table view. 2

[AnthonyGeorge]

I am writing a script that will add a column to a table

alter table <table_name> add <column_name>

This table has a view so I have to add that column to that view, no idea how to do this.

Thanks for any help.

Tony

 

[AnthonyGeorge]

Worked it out, you have to drop the view then do a new create view select statement.

Tony

 

[sem]

In fact you may CREATE OR REPLACE VIEW

Regards, Dima

http://seminihin.narod.ru

 

[jaggiebunnet]

You don't actually have to drop the view just have

CREATE OR REPLACE VIEW my_view
AS
SELECT *
FROM   mytable

instead of

CREATE VIEW my_view
AS
SELECT *
FROM   mytable

 

[AnthonyGeorge]

Thanks cuts down on the scripts I was going to write.

Tony