PowerShell SQL script table

gistfile1.ps1

# The file that the script is written to
$file = "C:\scripts\ps\department.sql"

# declare variables and create path
$server = "localhost";
$instance = "default";
$database = "timesheet";
$path = "sqlserver:\sql\$server\$instance\databases\$database\tables" ;

# filter down to a particular table
$tableName = "department";

$tableset = get-childitem $path -ErrorAction stop | where-object {$_.name -eq $tableName}  ;
$options = New-Object Microsoft.SqlServer.Management.Smo.ScriptingOptions ($srv);
$options.DriAllConstraints = $TRUE;

# We have filtered to a specified table, now script it   
$script = $tableset[0].script($options);      

#output the table to $file and console
write-host $script
$script | out-file $file -append -ErrorAction stop 
"GO" | out-file $file -append