|
|
|
Re: How to view the status of the constraints in a single table [message #351130 is a reply to message #351124] |
Mon, 29 September 2008 07:29 |
dkranes
Messages: 25 Registered: February 2008 Location: Upstate New York
|
Junior Member |
|
|
Here is a query:
set pagesize 1000 linsize 450
column table_name format a35
column constraint_name format a35
column column_name format a35
break on table_name skip 2
select
a.table_name,
a.constraint_name,
b.column_name
a.status
from USER_CONSTRAINTS a, USER_CONS_COLUMNS b
where
a.table_name = b.table_name and
a.constraint_name = b.constraint_name and
a.table_name = '<Your Table Here>'
order by
a.table_name,
a.constraint_name
/
Hope this helps.
David
|
|
|
|
|
|
|
Re: How to view the status of the constraints in a single table [message #351162 is a reply to message #351152] |
Mon, 29 September 2008 09:53 |
|
Michel Cadot
Messages: 68704 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
dkranes wrote on Mon, 29 September 2008 16:29 | Michel to be fair here the query is NOT wrong. It just contains more info than the OP asked for.
|
Why don't you also add all indexes, tablespaces with their free space and allocation map?
The question is simple, it just requires a single view with 2 output columns, one for the constraint name and one for the status.
Regards
Michel
[Updated on: Mon, 29 September 2008 09:55] Report message to a moderator
|
|
|
|
Re: How to view the status of the constraints in a single table [message #351165 is a reply to message #351157] |
Mon, 29 September 2008 09:59 |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
dkranes wrote on Mon, 29 September 2008 16:41 | Frank, the OP also asked for a query which you failed to provide. That is also part of the requirements.
Regards,
David
|
It's custom here at OraFAQ to not provide full-blown solutions for simple problems. We think we can help people more by pointing them in the right direction, then to give them the solution.
The "give a man a fish..." approach.
|
|
|
|
|
|
|