Drop Field

Does anyone know how to drop a field from an existing table in Sql. I tried Alter - Alter table <table-name> drop <field-name>, but gives error saying missing keyword at the field-name. Received on Sun Jul 05 1998 - 02:11:37 CDT