Page 1 of 1

ALTER TABLE

Posted: Thu Apr 12, 2001 4:53 pm
by vaibhav.choksey
I am trying to drop column from exisiting table using syntax: ALTER TABLE cmp_Header DROP COLUMN date_modified;
Give me error message: SQL call failed, syntax error at "TABLE".
I don't know how to drop the column, can you help me with that?
I don't have any thing in tables and they are not even indexed.

ALTER TABLE

Posted: Thu Apr 12, 2001 6:26 pm
by John
ALTER TABLE is not currently supported in Texis. With no data you can just drop and recreate the table.