Oninit cdi / Archive
Talk to an expert →

drop a column

Posted in 2003

Topics: General Discussion

GANESH RAM — — source: IIUG Forums & Mailing Lists

Hi Guys, Long time didn't work on Informix and my memory is rusted. Can someone tell me how to drop a column in IDS/XPS. Thanks Ganesh

↪ replying to GANESH RAM
Martin Fuerderer — — source: IIUG Forums & Mailing Lists

Hi, ALTER TABLE <tablename> DROP <column name> ; should do (in most cases). Regards, Martin -- Martin Fuerderer IBM Informix Development Munich Data Management Solutions "GANESH RAM" <ganesh.r@fmr.com> Sent by: forum.subscriber@iiug.org 03.12.2003 10:39 To: ids@iiug.org cc: Subject: drop a column [2283] Hi Guys, Long time didn't work on Informix and my memory is rusted. Can someone tell me how to drop a column in IDS/XPS. Thanks Ganesh

↪ replying to GANESH RAM
John Hoffman — — source: IIUG Forums & Mailing Lists

Fire up dbaccess and run the following sql statement: ALTER TABLE <table_name> DROP <column_name> -----Original Message----- From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org]On Behalf Of GANESH RAM Sent: Wednesday, December 03, 2003 4:39 AM To: ids@iiug.org Subject: drop a column [2283] Hi Guys, Long time didn't work on Informix and my memory is rusted. Can someone tell me how to drop a column in IDS/XPS. Thanks Ganesh

↪ replying to GANESH RAM
KOLAYA, SCOTT M — — source: IIUG Forums & Mailing Lists

Ganesh, In case you need more sql/ddl help, fire up dbaccess then start a new query in the built-in editor and press ctrl+w that will give you online help for the most commonly used commands. "Give a man a fish and he eats for a day. Teach a man to fish and he will never be hungry." -Lao Tzu Scott M. Kolaya Lead Database Administrator Fleet Libris Information Solutions Ph: 518-471-1830 Fax: 518-471-1841 <mailto:Scott_M_Kolaya@fleet.com> -----Original Message----- From: GANESH RAM [mailto:ganesh.r@fmr.com] Sent: Wednesday, December 03, 2003 4:39 AM To: ids@iiug.org Subject: drop a column [2283] Hi Guys, Long time didn't work on Informix and my memory is rusted. Can someone tell me how to drop a column in IDS/XPS. Thanks Ganesh

↪ replying to GANESH RAM
Jonathan Leffler — — source: IIUG Forums & Mailing Lists

RTF(abulous)M? ALTER TABLE TableName DROP ColumnName; -- Jonathan Leffler (jleffler@us.ibm.com) STSM, Informix Database Engineering, IBM Data Management 4100 Bohannon Drive, Menlo Park, CA 94025 Tel: +1 650-926-6921 Tie-Line: 630-6921 "I don't suffer from insanity; I enjoy every minute of it!" |---------+----------------------------> | | "GANESH RAM" | | | <ganesh.r@fmr.com| | | > | | | Sent by: | | | forum.subscriber@| | | iiug.org | | | | | | | | | 12/03/2003 01:39 | | | AM | |---------+----------------------------> >------------------------------------------------------------------------------- ----------------------------------------------------------------| | | | To: ids@iiug.org | | cc: | | Subject: drop a column [2283] | >------------------------------------------------------------------------------- ----------------------------------------------------------------| Hi Guys, Long time didn't work on Informix and my memory is rusted. Can someone tell me how to drop a column in IDS/XPS. Thanks Ganesh