SQL Server Performance

SQLDMO with views

Discussion in 'General DBA Questions' started by Chappy, Feb 6, 2004.

  1. Chappy New Member

    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

Share This Page