I have a simple DB that has around 20 different tables.
I want to add a column to every table whose name has "Report Date", and to give it a mm-yyyy value.
I can do it one table at the time by using this query:
USE [RSA]
GO
ALTER TABLE [dbo].[RSA_BIRMINGHAM_1941$]
ADD [month] nvarchar(255);
But it would be easier if I can alter them all at once.