Tables and PK

From: Mike Kennedy <mike.kennedy_at_mci.com>
Date: 1997/12/30
Message-ID: <2v8q.9187$BU2.1373305_at_news.internetMCI.com>#1/1


[Quoted] Hi everyone...I've wrestled with this for a while and can't seem to get the correct query. I'm trying to write a query to return the table names and the columns (in order) which comprise the primary keys (any constraints), indented. For example:

Tableone

    Col1        PK
    Col2        PK

    Col3
    Col4
    Col5 FK

Tabletwo.....etc

Any help would be appreciated....

--Mike Kennedy Received on Tue Dec 30 1997 - 00:00:00 CET

Original text of this message