Tag Archives: databases

Alter Table in Microsoft SQL Server Express

How to Alter a Table in Microsoft SQL Server Express

SQL Server Express is the free edition of Microsoft’s excellent database server. Understandably, Microsoft chose to cripple the free version to create some differentiation between product tiers.

There’s one cripple, however, that makes no sense to me. Microsoft chose to disallow the use of ALTER TABLE statements. But why block these statements when the workaround is so simple…
Continue reading