I got this to work. Obviously need to add more columns as required
$null =
[reflection.assembly]::LoadWithPartialName("Microsoft.SqlServer.ConnectionInfo")
$null =
[reflection.assembly]::LoadWithPartialName("Microsoft.SqlServer.SmoEnum")
$null = [reflection.assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo")
$Server = new-object Microsoft.SqlServer.Management.Smo.Server("RSSQL1")
$db = $server.Databases["Test"]
$table = New-Object Microsoft.SqlServer.Management.Smo.Table($db, "NewTable")
$dt1 = [Microsoft.SqlServer.Management.Smo.Datatype]::Nchar(50)
$col1 = New-Object Microsoft.SqlServer.Management.Smo.Column($table, "Name",
$dt1)
$col1.Collation = "Latin1_General_CI_AS"
$col1.Nullable = $false
$table.Columns.Add($col1)
$table.Create()
--
Richard Siddaway
Please note that all scripts are supplied "as is" and with no warranty
Blog:
http://richardsiddaway.spaces.live.com/
PowerShell User Group:
http://www.get-psuguk.org.uk
"Shay Levi" wrote:
Quote:
> Try
>
> http://www.databasejournal.com/featu...le.php/3691566
>
>
> Shay
> http://scriptolog.blogspot.com
>
>
> Quote:
> > Hello,
> >
> > I am fairly new to Powershell and certainly not to familiar with SMO,
> > so really need some help with this problem I’ve encountered.
> >
> > I’m essentially trying to script the creation of a SQL Server 2005
> > database with the applicable entities using SMO. I have successfully
> > created a database using SMO, but not too sure on how to script the
> > creation of new entities and add them to a particular database. I have
> > searched high and low but can’t find any relevant information on the
> > subject.
> >
> > I have found a useful add-on called PowerSMO but this can only be used
> > for test purposes whereas I will be implementing my work into
> > production.
> >
> > I guess I’ll have to use something like
> > ‘Microsoft.SqlServer.Management.Smo.Table’ but I’m not entirely sure
> > of the syntax or how to implement this object.
> >
> > If anyone can answer my question or point me in the right direction
> > (any direction) I’d really appreciate it.
> >
> > Thanks,
> >
>
>
>