Home » RDBMS Server » Server Administration » Another question......
Another question...... [message #371329] Wed, 04 October 2000 04:17 Go to next message
Samuel
Messages: 17
Registered: September 2000
Junior Member
Ohhh I forgot that i have another question.
I know that there are some tables in Oracle that contains the fields, the table name etc... where declared the primary keys and the foreign keys...
A table is User_constraints, but i don't know wich are the others
thanks and i am sorry for my bad english....
Re: Another question...... [message #371330 is a reply to message #371329] Wed, 04 October 2000 05:06 Go to previous messageGo to next message
Gs
Messages: 8
Registered: September 2000
Junior Member
As I know ..........

USER_CONSTRAINTS
USER_CONS_COLUMNS
ALL_CONSTRAINTS
ALL_CONS_COLUMNS
DBA_CONSTRAINTS
DBA_CONS_COLUMNS
Re: Another question...... [message #371332 is a reply to message #371330] Wed, 04 October 2000 06:21 Go to previous message
Samuel
Messages: 17
Registered: September 2000
Junior Member
thank you very much, can you help me with the other problem?
bye bye
Previous Topic: update command
Next Topic: Exception handlers in cursor loops
Goto Forum:
  


Current Time: Thu Mar 28 19:38:17 CDT 2024