Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f5MCkha52893 for ; Fri, 22 Jun 2001 08:46:43 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from mercury.tsunamicreek.com (nat209.244.mpoweredpc.net [142.177.209.244]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5KJ44a78253 for ; Wed, 20 Jun 2001 15:04:04 -0400 (EDT) (envelope-from jeff@tsunamicreek.com) Received: from localhost (bignose@localhost) by mercury.tsunamicreek.com (8.11.2/8.11.2) with ESMTP id f5KJ7YC79359 for ; Wed, 20 Jun 2001 16:07:34 -0300 (ADT) (envelope-from jeff@tsunamicreek.com) X-Authentication-Warning: mercury.tsunamicreek.com: bignose owned process doing -bs Date: Wed, 20 Jun 2001 16:07:33 -0300 (ADT) From: X-X-Sender: Reply-To: To: Subject: constraints, Message-ID: <20010620160634.H69834-100000@mercury.tsunamicreek.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200106/358 X-Sequence-Number: 3645 Hello folks, wondering how to display any constraints that a table may have, as well i know alter table add constraint works, but what's the syntax to remove one ? i assume /alter table remove constraint, but i can't find any examples. jeff