X-Original-To: pgsql-chat-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 61566D1B941 for ; Sat, 23 Aug 2003 11:34:01 -0300 (ADT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 23608-08 for ; Sat, 23 Aug 2003 11:33:54 -0300 (ADT) Received: from mta07-svc.ntlworld.com (mta07-svc.ntlworld.com [62.253.162.47]) by svr1.postgresql.org (Postfix) with ESMTP id E8C05D1BAA8 for ; Sat, 23 Aug 2003 11:33:49 -0300 (ADT) Received: from ninjaiilfmsrao ([80.1.111.79]) by mta07-svc.ntlworld.com (InterMail vM.4.01.03.37 201-229-121-137-20020806) with SMTP id <20030823143351.JPFF27190.mta07-svc.ntlworld.com@ninjaiilfmsrao> for ; Sat, 23 Aug 2003 15:33:51 +0100 Message-ID: <001601c36983$8f9c8e20$4f6f0150@ninjaiilfmsrao> From: "leon alexander" To: Subject: how to Adding a foreign key to a table already created??? Date: Sat, 23 Aug 2003 15:33:37 +0100 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0013_01C3698B.EB99C640" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.6 tagged_above=0.0 required=5.0 tests=HTML_30_40 X-Spam-Level: X-Archive-Number: 200308/10 X-Sequence-Number: 11 This is a multi-part message in MIME format. ------=_NextPart_000_0013_01C3698B.EB99C640 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable hi there, i have already created a table.The next table (artist), i would like to cre= ate requires a foreign key (cd_no) from a table (cd) which cannot be create= d until the table (artist) is made. Can i add the foreign key (cd_no) too t= he 'artist' table later??? leon ------=_NextPart_000_0013_01C3698B.EB99C640 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
hi there,
i have already created a table.The next ta= ble=20 (artist), i would like to create requires a foreign key (cd_no) from a tabl= e=20 (cd) which cannot be created until the table (artist) is made. Can i add th= e=20 foreign key (cd_no) too the 'artist' table later???
leon
------=_NextPart_000_0013_01C3698B.EB99C640--