Reading DB structure

From: Petar Petrovic (mojne_at_uznemiravati.me)
Date: 11/30/03 

Date: Sun, 30 Nov 2003 14:05:07 +0100

Hi gurus,

I need to read DB structure and put it in some sort of tree. While the
second part is not that complicate what confuses me at the moment is how to
extract db info from current DB. At the moment it is SQL Server, but I would
like to make it more generally for InterBase, Oracle, etc.

The question is: is there possibility to obtain this info using some ADO
calls, or I need to go directly to particular RDBMS and, for instance, read
the contents of SYSTABLE from SQL Server?

Also, are there 3rd party libs that are maybe doing this?

Thanks and regards!

Relevant Pages

  • Re: Tree Structures
    ... Versatile High Performance Hierarchies in SQL Server ... > the application uses a tree structure. ... this is in the form of a stored procedure and so ... > * create the tree using recursive queries in the asp code - i would ...
    (microsoft.public.sqlserver)
  • Re: implementing hierarchy
    ... out preview copies of "Tree & Graph Processing in SQL: ... and Trees and breadth-first tree processing. ... "got" the difference between relational programming and procedural ... Pro SQL Server 2000 Database Design - ...
    (microsoft.public.sqlserver.programming)
  • Joe Celkos examples fail
    ... I need to be able to process trees in SQL Server. ... --Celko p. 32 modified for PartsExplosion tree ... -- set root to 1, ... DO UPDATE PartsExplosion ...
    (microsoft.public.sqlserver)
  • Re: Clustering and SA Role
    ... You can grant someone to only manage objects in a certain tree, ... Do you trust the same person not to give themselves Enterprise Admin rights ... Mike Epprecht, Microsoft SQL Server MVP ... anyone who can add members to groups in the ...
    (microsoft.public.sqlserver.clustering)
  • Re: Connecting to a SQL Server Database
    ... Nope - you are not barking up the wrong tree. ... You have describe one of the key reasons for moving to SQL Server. ... If you "simply" move your tables to SQL Server and re-link them in your mdb ... ADP projects use ADO ...
    (microsoft.public.access.externaldata)