Home » SQL & PL/SQL » SQL & PL/SQL » Table Type list from a schema
Table Type list from a schema [message #196184] Wed, 04 October 2006 07:41 Go to next message
marlon_loyolite
Messages: 66
Registered: July 2006
Member
Hi Friends,
I just wanted to display the schema tables in the following format

1. BASE TABLES = If it has Primary Key and the key is referenced in some other tables.
2. DATA TABLES = If the table has only referenced from some other table.

Regards
Marlon
Re: Table Type list from a schema [message #196203 is a reply to message #196184] Wed, 04 October 2006 08:29 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
How do you want to dipsplay tables that both reference and are referenced by other tables?
Re: Table Type list from a schema [message #198019 is a reply to message #196184] Fri, 13 October 2006 18:57 Go to previous message
Kevin Meade
Messages: 2101
Registered: December 1999
Location: Connecticut USA
Senior Member
Try this, it stacks tables by FK references. May be more than you need.

Kevin
Previous Topic: JOIN WITH PROCEDURE
Next Topic: Integrity Constraint error
Goto Forum:
  


Current Time: Sat Dec 10 16:41:32 CST 2016

Total time taken to generate the page: 0.07297 seconds