Re: Views question?

Daniel Morgan said: > Obnoxio The Clown wrote: > >> Mark Townsend said: >> >>>Obnoxio The Clown wrote: >>> >>>>Mark Townsend said: >>>> >>>> >>>> >>>>>BTW - as a trivia question - which of the big three databases STILL >>>>>doesn't have drop column ? >>>> >>>> >>>>Must be SQL Server... :o) >>>> >>> >>>Brrrt. No. Thanks for playing, next caller please. >> >> >> Well, then, it must be Oracle, because I know Informix has it. > > Not a chance. In Oracle ... > > ALTER TABLE <table_name> > DROP COLUMN <column_name>; > > And it has been there for many versions. I know, Daniel, I know. I've used it. It was an ironic joke. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco http://www.catb.org/~esr/faqs/smart-questions.html sending to informix-list