Monthly Archives: December 2009

This times lets go mad and delete a whole table. 001002003004005006007008009010011 function Remove-AccessTable {[CmdletBinding(SupportsShouldProcess=$true)]param (    [string]$table,    [System.Data.OleDb.OleDbConnection]$connection)    $sql = "DROP TABLE $table "    $cmd = New-Object System.Data.OleDb.OleDbCommand($sql, $connection)        if ($psCmdlet.ShouldProcess("$($connection.DataSource)", "$sql")){$cmd.ExecuteNonQuery()}} Again we use the SupportsShouldProcess – have to love the amount of functionality we get for one line of … Continue reading →

We have seen how to add a column to our access database – what about removing a column? 001002003004005006007008009010011012 function Remove-AccessColumn {[CmdletBinding(SupportsShouldProcess=$true)]param (    [string]$table,    [string]$column,    [System.Data.OleDb.OleDbConnection]$connection)    $sql = "ALTER TABLE $table DROP COLUMN $column"    $cmd = New-Object System.Data.OleDb.OleDbCommand($sql, $connection)        if ($psCmdlet.ShouldProcess("$($connection.DataSource)", "$sql")){$cmd.ExecuteNonQuery()}}   We use the SupportsShouldProcess=$true to get the … Continue reading →

Now we have created our Table we can start adding columns 001002003004005006007008009010011012013014015016017018019020021022023024025026027028029030031032033034035036037038039040041042043044045046047048049050051052053054055056057058059060061062063064065066067068069070071072073074075076077078079080081082083084085086 function New-AccessColumn {[CmdletBinding()]param (    [System.Data.OleDb.OleDbConnection]$connection,    [string]$table,    [switch]$notnull,     [parameter(ParameterSetName="datetime")]      [string]$dtname,     [parameter(ParameterSetName="unique")]      [string]$uniquename,     [parameter(ParameterSetName="binary")]      [string]$binname,     [parameter(ParameterSetName="bit")]      [string]$bitname,     [parameter(ParameterSetName="tinyinteger")]      [string]$tnyintname,     [parameter(ParameterSetName="smallinteger")]      [string]$smlintname,   … Continue reading →

I have already presented a function to create a new access table but I wasn’t very happy with it because we had to supply the full table creation SQL script. I have altered that function so it creates an empty … Continue reading →