how to "ADD COLUMN"

[sliver]

here is my query it is on a sql server/coldfusion system.

<cfquery name=&quot;adding&quot; datasource=&quot;clientname&quot;>
ALTER TABLE subjects ADD COLUMN partnerid VARCHAR(30)
</CFQUERY>

from everything I can find it should work but it doesnt.
I get
Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'COLUMN'.

please help

 

[zhavic]

remove word 'COLUMN' from it:

ALTER TABLE subjects ADD partnerid VARCHAR(30)


Zhavic


---------------------------------------------------------------
In the 1960s you needed the power of two Comodore64s to get a rocket to the moon. Now you need a machine which is a vast number of times more powerful just to run the most popular GUI.