Add COLUMN keyword to the ADD COLUMN SYNTAX (as alternate) - by Louis Davidson

Status : 

 


23
0
Sign in
to vote
ID 124626 Comments
Status Active Workarounds
Type Suggestion Repros 3
Opened 6/18/2005 8:51:25 PM
Access Restriction Public

Description

The problem is that it is wierd that 
ALTER TABLE
   ALTER COLUMN  
is the syntax for altering, 
ALTER TABLE
   DROP COLUMN 
is the syntax for dropping, but
ALTER TABLE 
   ADD COLUMN 
is NOT the syntax for adding a column.

Sign in to post a comment.
Posted by Umachandar [MSFT] on 1/15/2010 at 1:00 PM
Hi Louis,
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
Posted by Sacheveral on 12/27/2008 at 8:13 AM
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).
Posted by Razvan Socol on 10/16/2008 at 3:07 AM
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).
Posted by Louis Davidson on 8/29/2008 at 7:31 AM
Reopened as it was marked closed-fixed, yet it still works the same way in 2008.
Posted by Microsoft on 11/14/2007 at 11:19 AM
Hi,

We are tracking this request as a part of another item and we will consider fixing this in a future release.

Thanks,
-Vineet Rao
Posted by Microsoft on 9/13/2006 at 10:12 AM
Hi,
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.

Thanks,
- Balaji Rathakrishnan
Group Program Manager
Microsoft SQL Server