• Thanks for the reply.

    But is there a command like ALTER VIEW view_name ADD column_name datatype