SQL Statement

From: Alexandr Reshitko <aresitko_at_skh.cz>
Date: Wed, 2 Sep 1998 17:24:11 +0200
Message-ID: <6sjnot$qfg$1@ns.felk.cvut.cz>

Hi,
How can I write a statement that returns list of all columns in a database and if any column a primary key or not?

I trying:
SELECT Sys.All_Tab_Columns.Table_Name,

                    Sys.All_Tab_Columns.Column_Name,
                    Sys.All_Cons_Columns.Constraint_Name,
                    Sys.All_Constraints.Constraint_Type
FROM        Sys.All_Tab_Columns,
                    Sys.All_Cons_Columns,
                    Sys.All_Constraints
WHERE     Sys.All_Tab_Columns.Column_Name = Sys.All_Cons_Columns.Column_Name


(+) AND


                    Sys.All_Constraints.Constraint_Name (+) =
Sys.All_Cons_Columns.Constraint_Name AND
                    Sys.All_Constraints.Constraint_Type (+) = 'P'

but its works wrong because its list some columns twice or more
(some different constraints refers to the same columns).

So, how can I limit this statement and except columns reduplication. Or may be exists an other idea?

Thanks in advance. Received on Wed Sep 02 1998 - 10:24:11 CDT