Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!zaphod.mps.ohio-state.edu!samsung!umich!wsu-cs!artemis.cs.wayne.edu!nis From: nis@artemis.cs.wayne.edu (Nitin Shah) Newsgroups: comp.databases Subject: Dropping an attribute in ORACLE Keywords: Field, ALTER TABLE, ORACLE Message-ID: <1991Mar19.214606.29393@cs.wayne.edu> Date: 19 Mar 91 21:46:06 GMT Sender: News@cs.wayne.edu Organization: Wayne State University Lines: 18 I would like to thank all of you folks who cared to reply for my question on division operation in ORACLE. It really helped. I have another question. Is it possible to drop a field from the schema in ORACLE ? Sql command ALTER TABLE only allows to ADD new field or MODIFY existing fields. It only allows you to drop constraint on column not column itself. Either email me personally or post in this new group. Thanks folks, Nitin email : nis@cs.wayne.edu