SQL views and procedures - SQL statements

How does one read the SQL source statement for views and Procedures I can read the collection e.g.

Dim schemaTable As DataTable = cnnoledb.GetOleDbSchemaTable(_(System.Data.OleDb.OleDbSchemaGuid.Tables, New Object() {Nothing, Nothing, Nothing, "VIEW"})

But there is no way I can find to get to the SQL source statements to EDIT the text and "CREATE VIEW" a new one

Any clues would be appreciated

jimbo(nospam)@csh.com.au          <<<<Seasons Greetings  to all>>>>

 




Answer this question

SQL views and procedures - SQL statements

  • SQL views and procedures - SQL statements