>How can i delete a view programmatically.
>
>viewname is subdwgview.
>
>Thank you.

DROP VIEW subdwgview

Keep in mind that adding and deleting views will cause DBC bloat because space taken by it isn't released when it's dropped.