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....

Report message to a moderator

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

Report message to a moderator

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

Report message to a moderator

Previous Topic: update command
Next Topic: Exception handlers in cursor loops
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 22 11:17:59 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.