I know this should be stupidly easy to do but I'm pulling my hair out trying to figure out how to write a SQL query to add a column to an existing table with SQL Server 2005. Every single reference I've found says to use "ALTER TABLE", yet when I do SQL says...
"The ALTER TABLE SQL construct or statement is not supported."
So how the $%^$ am I supposed to add a column I've wasted about 3 hours on this simple task and it's really starting to piss me off.
Add a column to a table.
Orchid2006
That's where it gives me the error. A simple statement like this does it.
ALTER TABLE History ADD Mar06 int
Even if I just do this query it says it too.
ALTER TABLE History
In Management Studio it pops up the error message and gives me a choice of clicking "Continue" or "Cancel". If I click "Contine" it does the query and it works, but if I do the exact same query from a PHP script it doesn't work, even through the rest of the queries in the script work just fine. I don't get it at all. The full query that I want to run is...
ALTER TABLE History ADD Mar06 int DEFAULT 0 NOT NULL
Edit: Okay, I finally figured it out and it seems the user I was logged in as didn't have ALTER permissions. That error message was making me think it was something wrong with my query so that's what I was focused on fixing. It looks to be working fine now, though that error message still pops up.
Simon T
Hi,
from where are you firing your query iring the query from the query ane of the Managment studio just works fine for me with the following script.
USE ADVENTUREWORKS
GO
DROP
TABLE SomeTableGO
CREATE
TABLE SomeTable(
SomeColumn
INT)
ALTER
TABLE SomeTableADD
SomeCOlumn2 INTHTH, Jens Suessmeyer.
---
http://www.sqlserver2005.de
---