# Requirement: Change all tables whose name is T100 to 199
with a new schema name. The $ at the end of T1[0-9][0-9]$ is to eliminate
T1[0-9][0-9][0-9]...
PS SQLSERVER:\SQL\XU-ACER-PC\DEFAULT\Databases\MyTestDB\Tables>
dir |? {$_.Name -match "T1[0-9][0-9]$"} | %{$_.Name; $_.ChangeSchema("MyNewSchema");$_.Alter()}
