List all the views in a given SQL Server database.
' Local Computer strDBServerName = "." strDBName = "Northwind" ' Change database as required Set objSQLServer = CreateObject("SQLDMO.SQLServer") ' Integrated Security objSQLServer.LoginSecure = True objSQLServer.Connect strDBServerName Set colViews = objSQLServer.Databases(strDBName).Views ' List Views For Each objView In colViews WScript.Echo objView.Name Next