I've got a SQL Server
database running in SSMS
which contains ~75 tables. I've just realized every table has a modfiedBy
column header, which is misspelled and should instead be spelled modifiedBy
.
Is there a way to change (ALTER
??) all these column headers programatially via SQL
, so that I don't have to right click --> design and manually respell it on every single table? Could anyone provide an example that may work?