SQL Server Performance Forum – Threads Archive

SQLDMO with views

Hi all,
Im using SQLDMO to script out an assortment of tables. I now want to script some views.. now I can get DMO to script out the schema of the view as a CREATE VIEW statement, but what im wanting is some way to instead, script the VIEW as if it were a table.. ie instead of the VIEW definition, i want the view structure in terms of field int, field2 varchar(20) etc etc Has anyone done this before ? Cheers

---

]]>