EPISODE · May 18, 2012 · 8 MIN
Change Schema in Powershell
from Midnight DBA
Changing object schemas is easy enough in T-SQL when it's a single object, but it get considerably more complicated when you've got several objects to change, or even several thousand. This is where Powershell comes in. Here I show you how to very easily change the schema of as many objects as you like in just a few seconds. And I throw in some regex in there for good measure. Let's have some fun.
What this episode covers
Changing object schemas is easy enough in T-SQL when it's a single object, but it get considerably more complicated when you've got several objects to change, or even several thousand. This is where Powershell comes in. Here I show you how to very easily change the schema of as many objects as you like in just a few seconds. And I throw in some regex in there for good measure. Let's have some fun.
NOW PLAYING
Change Schema in Powershell
No transcript for this episode yet
Similar Episodes
Jul 17, 2026 ·102m
Jul 14, 2026 ·121m
Jul 10, 2026 ·92m