ALTER TABLE tablename DROP COLUMN columnname;
from my SQL Assistant, It runs file, but when I run the same in Studio it fails to run.
ALTER TABLE tablename DROP columnname;
runs fine in STUDIO.
Chiran, ODBC is doing special handling for the query that .NET and JDBC do not. The Teradata documentation (SQL Data Definition Language Syntax and Examples) shows the syntax for ALTER TABLE with DROP followed by a name. The first example also fails when parsing the SQL in the SQL Editor.