Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 14669 invoked from network); 7 Sep 2007 13:35:04 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 7 Sep 2007 13:35:04 -0000 Received: (qmail 37942 invoked by uid 500); 7 Sep 2007 13:34:56 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 37916 invoked by uid 500); 7 Sep 2007 13:34:56 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 37905 invoked by uid 99); 7 Sep 2007 13:34:56 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 07 Sep 2007 06:34:56 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of brdohman@eiu.edu designates 139.67.14.61 as permitted sender) Received: from [139.67.14.61] (HELO fillmore.eiu.edu) (139.67.14.61) by apache.org (qpsmtpd/0.29) with SMTP; Fri, 07 Sep 2007 13:34:52 +0000 Received: from [192.168.1.104] (unknown [12.206.0.57]) by fillmore.eiu.edu (Postfix) with ESMTP id D5AAB2CF8BCA for ; Fri, 7 Sep 2007 08:34:27 -0500 (CDT) Message-ID: <46E16F7F.5070405@eiu.edu> Date: Fri, 07 Sep 2007 08:34:23 -0700 From: Brandon Dohman User-Agent: Thunderbird 2.0.0.6 (Windows/20070728) MIME-Version: 1.0 To: Derby Discussion Subject: how to remove a column Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org I was wondering what the sql syntax is to drop a column from a derby database. i tried this and it gave me the error below: ALTER TABLE contacts DROP COLUMN userid Error code -1, SQL state 42X01: Syntax error: Encountered "DROP" at line 1, column 22. Line 1, column 1 Thanks for your help