SQL Statement

From: Alexandr Reshitko <aresitko_at_skh.cz>
Date: Wed, 2 Sep 1998 18:00:02 +0200
Message-ID: <6sjpsf$38d$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 - 11:00:02 CDT