Powershell – Getting tables from a SQL Server database

c:\Users\adm-showard>powershell
Windows PowerShell
Copyright (C) 2009 Microsoft Corporation. All rights reserved.

PS C:\Users\adm-showard> $sqlConn = New-Object System.Data.SqlClient.SqlConnection
PS C:\Users\adm-showard> $sqlConn.ConnectionString = "Server=CMHWPSWSQL1201;Integrated Security=true;Initial Catalog=SWNetPerfMon"
PS C:\Users\adm-showard> $sqlConn.Open()
PS C:\Users\adm-showard> $sqlcmd = $sqlConn.CreateCommand()
PS C:\Users\adm-showard> $sqlcmd = New-Object System.Data.SqlClient.SqlCommand
PS C:\Users\adm-showard> $sqlcmd.Connection = $sqlConn
PS C:\Users\adm-showard> $query = "select distinct table_name from SWNetPerfMon.information_schema.columns where lower(column_name) like '%thresh%'"
PS C:\Users\adm-showard> $sqlcmd.CommandText = $query
PS C:\Users\adm-showard> $adp = New-Object System.Data.SqlClient.SqlDataAdapter $sqlcmd
PS C:\Users\adm-showard> $data = New-Object System.Data.DataSet
PS C:\Users\adm-showard> $adp.Fill($data) | Out-Null
PS C:\Users\adm-showard> $data.Tables

table_name
----------
APM_AlertsAndReportsData
APM_DynamicEvidence



VoipThresholdTypes
VolumesForecastCapacity
VolumesPercentDiskUsedForecastCapacity


PS C:\Users\adm-showard>