How to delete a field from specific table..?

[kamal_sanguri]

Hi,

I have stuck  in situation where I need to drop one field from one table.

If I use DROP FIELD <F1> command, the <F1> field from the other table also gets deleted and I do not want to delete it from there. Any help would be greatly appreciated.

Thanks,

Kamal

[jonasheisterkam · Accepted solution]

drop field A from X;

[chiru_thota]

Both drop field and drop fields are allowed forms with no difference in effect.
If no table is specified, the field will be dropped from all tables where it occurs.

Examples:

drop field A;

drop fields A,B;

drop field A from X;

drop fields A,B from X,Y;