Re: How can I see Integrity Rules?

    Buenas !!

Eva Serralvo wrote:

> I would like to know how can I see Integrity Rules in my DB, ¿which
> opcion
> enables me to see and update this rules?

   Firs of all, think next time to begin with something more funny. Something linke:

    Hi !

(usually we are working and msg like you are a little boring ;)

    You can find this information in the 'Oracle7 Server SQL Reference' (I know you are using Oracle7)

    Then, go to index, and click on 'Integrity Constraits'

    There, you'll become documented into the integrity world, knowing what is a data dictionary (that I previously explained via netmail) and other things.

    Anycase, the solution:

SELECT          A.TABLE_NAME
,                       B.CONSTRAINT_NAME
FROM            USER_TABLES             A
,                       USER_CONSTRAINTS        B
WHERE           B.TABLE_NAME = A.TABLE_NAME;

and a little information about some useful things:

1. If you're looking for a table, try finding it with "select table_name from all_tables where table_name like '%findme%';".
2. If you want to know the structure, try "desc <table_name>"
3. If you want to look something up in an Oracle book, make sure it's in your language.
4. If you get worried, because you still don't know what to do, ask a collegue or the DBA.
5. If all of the above doesn't work, put your question in the newsgroup, politely!

Try readin' it next time!

Sorry for my poor level of english.

Cheers,
Jordi Bellver Received on Thu Nov 13 1997 - 00:00:00 CST