ALTER TABLE

Post Reply
vaibhav.choksey
Posts: 17
Joined: Tue Apr 10, 2001 11:14 am

ALTER TABLE

Post 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.
User avatar
John
Site Admin
Posts: 2622
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

ALTER TABLE

Post by John »

ALTER TABLE is not currently supported in Texis. With no data you can just drop and recreate the table.
John Turnbull
Thunderstone Software
Post Reply