Free for PREMIUM members
[Webinar] Streamline your web hosting managementRegister Today
The revolutionary project management tool is here! Plan visually with a single glance and make sure your projects get done.
Set oRS = Connection.OpenSchema(20)
Do While Not oRS.EOF
If oRS("TABLE_TYPE").Value = "VIEW" Then
sViewName = oRS("TABLE_NAME").Value
sViewName = "vw_myview"
Set oRS = Connection.Execute("SELECT VIEW_DEFINITION FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME ='" & sViewName & "'")
sViewCode = oRS("VIEW_DEFINITION").Value
Open in new window
Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.