RE: Which system table lists the constrain names in a database?

Posted in 2000

DiMisa, John — Tue, 18 Jul 2000 15:14:33 -0400 — source: Informix-list mailing list archive (1991-1998)

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BFF0EC.5E9679F2 Content-Type: text/plain; charset="iso-8859-1" How about "sysconstraints" it lists constrid, constrname, owner, tabid, constrtype, indxname. jd -----Original Message----- From: Raymond Chui [mailto:raymond.chui@noaa.gov] Sent: Tuesday, July 18, 2000 12:07 PM To: informix-list@iiug.org Subject: Which system table lists the constrain names in a database? This is a multi-part message in MIME format. --------------285190F5B1FC61D419A20DE7 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit The Subject says its all. For example, a constrain name r602_301, is there a system table list all these constrain names? Thank you! -- Why we want to teach our babies to talk and walk, then later we tell them "sit down!", "be quiet!" ? Democracy is not a better way for a solution, it is just another way to spread the blames. --Raymond --------------285190F5B1FC61D419A20DE7 Content-Type: text/x-vcard; charset=us-ascii; name="raymond.chui.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Raymond Chui Content-Disposition: attachment; filename="raymond.chui.vcf" begin:vcard n:Chui;Raymond tel;fax:(301)713-0963 tel;home:ICQ #: 16722494 tel;work:(301)713-0624 Ext. 168 x-mozilla-html:TRUE url:http://members.xoom.com/rchui/ org:NWS, NOAA version:2.1 email;internet:Raymond.Chui@noaa.gov title:SA, DBA adr;quoted-printable:;;NOAA, NWS, Office of Hydrology, W/OH2=0D=0A1325 East-West Highway, Room 8112;Silver Spring;MD;20910-3283;U.S.A. x-mozilla-cpt:;30256 fn:Raymond Chui end:vcard --------------285190F5B1FC61D419A20DE7-- ------_=_NextPart_001_01BFF0EC.5E9679F2 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2448.0"> <TITLE>RE: Which system table lists the constrain names in a = database?</TITLE> </HEAD> <BODY> How about "sysconstraints" it lists = constrid, constrname, owner, tabid, constrtype, indxname. jd -----Original Message----- From: Raymond Chui [<A = HREF=3D"mailto:raymond.chui@noaa.gov">mailto:raymond.chui@noaa.gov</A>]<= /FONT> Sent: Tuesday, July 18, 2000 12:07 PM To: informix-list@iiug.org Subject: Which system table lists the constrain = names in a database? This is a multi-part message in MIME format. --------------285190F5B1FC61D419A20DE7 Content-Type: text/plain; charset=3Dus-ascii Content-Transfer-Encoding: 7bit The Subject says its all. For example, a constrain name r602_301, is there a = system table list all these constrain names? Thank you! -- Why we want to teach our babies to talk and = walk, then later we tell them "sit down!", = "be quiet!" ? Democracy is not a better way for a solution, it is just another way to spread the blames. --Raymond --------------285190F5B1FC61D419A20DE7 Content-Type: text/x-vcard; = charset=3Dus-ascii;  name=3D"raymond.chui.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Raymond Chui Content-Disposition: attachment;  filename=3D"raymond.chui.vcf" begin:vcard n:Chui;Raymond tel;fax:(301)713-0963 tel;home:ICQ #: 16722494 tel;work:(301)713-0624 Ext. 168 x-mozilla-html:TRUE url:<A HREF=3D"http://members.xoom.com/rchui/"; = TARGET=3D"_blank">http://members.xoom.com/rchui/</A>; org:NWS, NOAA version:2.1 email;internet:Raymond.Chui@noaa.gov title:SA, DBA adr;quoted-printable:;;NOAA, NWS, Office of = Hydrology, W/OH2=3D0D=3D0A1325 East-West Highway, Room 8112;Silver = Spring;MD;20910-3283;U.S.A. x-mozilla-cpt:;30256 fn:Raymond Chui end:vcard --------------285190F5B1FC61D419A20DE7-- </BODY> </HTML> ------_=_NextPart_001_01BFF0EC.5E9679F2--

RE: Which system table lists the constrain names in a database?

Related threads

Your privacy choices