Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- all_cons_columns.owner AS schema_name,
- all_cons_columns.table_name,
- all_cons_columns.column_name,
- ALL_CONS_COLUMNS.POSITION,
- ALL_CONS_COLUMNS.CONSTRAINT_NAME,
- all_constraints.status
- FROM all_constraints, all_cons_columns
- WHERE
- all_constraints.constraint_type = 'P'
- AND all_constraints.constraint_name = all_cons_columns.constraint_name
- AND all_constraints.owner = all_cons_columns.owner
- ORDER BY
- all_cons_columns.owner,
- ALL_CONS_COLUMNS.TABLE_NAME,
- all_cons_columns.position;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement