Altering Multiple Tables SQL Server

Viewed 2168

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.

1 Answers
Related