Am trying to generate a hierarchy of tables in our sybase database. I have a perl script that does this but it is not very efficient. The perl script gets the constraint information for every table but it is a performace hog when it comes to recursive information retrieval and traversal. Would it be possible to generate this hierarchy in a single sql query or stored procedure. If so, any help in this regard is greately appreciated. Thanks
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Generating table hierarchy in sybase
- Thread starter cvg2mco
- Start date
Similar threads
- Locked
- Question
- Locked
- Question