Add COLUMN keyword to the ADD COLUMN SYNTAX (as alternate)
The problem is that it is wierd that
is the syntax for altering,
is the syntax for dropping, but
is NOT the syntax for adding a column.
Upvotes: 24<=-=Sep 13 2006 10:12AM=-=>
Thanks for the suggestion. Yes there is an inconsistency in ALTER TABLE syntax for adding columns. We will look into fixing this in the next release.
- Balaji Rathakrishnan
Group Program Manager
Microsoft SQL Server
We are tracking this request as a part of another item and we will consider fixing this in a future release.
Reopened as it was marked closed-fixed, yet it still works the same way in 2008.<=-=Oct 16 2008 3:07AM=-=>
I find it interesting that SQL Server Compact Edition 3.5 allows a “ALTER TABLE tbl ADD COLUMN col1” command, even if the COLUMN keyword is not documented in the ALTER TABLE syntax (http://msdn.microsoft.com/en-us/library/ms174123.aspx).<=-=Dec 27 2008 8:13AM=-=>
Consistency is everything. I am sure that most people type ‘add column’ like I do, then go back and change it when it won’t execute and curse themselves (and MS).<=-=Jan 15 2010 1:00PM=-=>
Thanks for your feedback. I have marked this as duplicate of another feedback item in our system. This item was opened using an older bug tracking system and there is some issues in dealing with that cleanly. So as a result, I had to mark this one as duplicate.
Umachandar, SQL Programmability Team