...

View Full Version : Adding a column to multiple tables at once



wincode
12-31-2011, 07:00 PM
Hi, how do you add a column to multiple tables at once? Is it possible?

Thanks

Old Pedant
01-02-2012, 01:04 AM
If you mean with one SQL statement, no, it's not possible.

If you mean with one Stored Procdefure, yes, it is.

If you mean with a handful of PHP/JSP/ASP statements, yes, it is.

But the very fact you are asking this question makes me thing you may have a bad database design. For example, if you have one table for each user or something like that, you have a bad design. You might want to show us at least an outline of your DB schema.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum