Windows PowerShell and SMO - Professional SQL Server 2008 Administration with Windows PowerShell - page 304

$server = New-Object ('Microsoft.SqlServer.Management.Smo.Server')
"PowerServer3\SQL2008"
$database = $server.Databases["msdb"]
$database.Views | Select-Object Name
$database.StoredProcedures | Select-Object Name
Figure 13-30
Figure 13-31
Working with Tables using SMO
So far, you have seen the various uses of SMO. SMO can also be used to create and manipulate database
objects such as tables, stored procedures, functions, and more. This section illustrates the use of SMO in
accessing and manipulating the database object tables.