Spacewalk DB Schema - View-ALL_PRIMARY

Main Tables Views Materialized Views Indexes Constraints Triggers Procedures Functions Packages Sequences Java Sources Jobs Sanity Check Index DDL scrips

Description Columns Query Constraints Triggers

ALL_PRIMARY_KEYS

DDL script

Columns

Name	Type	Nullable	Insertable	Updatable	Deletable
TABLE_NAME	VARCHAR2(30)	N	NO	NO	NO
CONSTRAINT_NAME	VARCHAR2(30)	N	NO	NO	NO
COLUMN_NAME	VARCHAR2(4000)	Y	NO	NO	NO

Query:

Legend: comment string keyword reserved word operator

select
       ac.table_name,
       ac.constraint_name,
       acc.column_name
  from all_constraints ac
  join all_cons_columns acc
    on ac.constraint_name = acc.constraint_name
   and ac.owner = acc.owner
 where ac.constraint_type = 'P'