Microsoft® SQL Server 2012 Unleashed

Creating a Database Table

Creating a database and a table are common tasks that a DBA may undertake. You can use T-SQL with the Invoke-SqlCmd cmdlet to do this, but a demonstration on how to do this with the SQL Server PowerShell using SMO is presented here to help you better understand the different types of functionality that are available:

Click here to view code image

cd databases$my_db=New-Object Microsoft.SqlServer.Management.Smo.Database$my_db.Name="my_database"$my_db.Parent=(Get-Item ..)$my_db.Create()cd my_databasecd tables$my_tbl=New-Object Microsoft.SqlServer.Management.Smo.Table$my_tbl.Name="my_table"$my_tbl.Parent=(Get-Item ..)$my_col=New-Object Microsoft.SqlServer.Management.Smo.Column$my_col.Name="my_column"$my_col.Parent=$my_tbl ...