Why isn't my ALTER clause?

[programmher]

I get the below message upon execution of my ALTER clause:


ODBC Error Code = 37000 (Syntax error or access violation)


[MERANT][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'COLUMN'.


SQL = "ALTER TABLE tbl_States ADD COLUMN states counter PRIMARY KEY"

Data Source = "MyDatabase"

I am following the example as it appears on page 244 of the CF 4.5 book. Below is my code:

<cfquery name=&quot;addcolumn&quot; datasource=&quot;MyDatabase&quot;>

ALTER TABLE tbl_States

ADD COLUMN states VARCHAR(2)


</cfquery>

Can anyone shed some light?

 

[GunJack]

The syntax for altering tables is not standard across databases. Try removing &quot;column&quot; so it reads

ALTER TABLE tbl_States
ADD states VARCHAR(2)

Hope this helps,
GJ

 

[programmher]

GJ,

I FINALLY figured that out and my query works great! Thanks for posting my answer. It's good to know I had an answer waiting for me!

P