using system tables

[NevG]

Hi troops

Im trying to add a kind of abstraction layer to SQL Server by adding my own SP's that accept a table name and spits out a ball of XML containing columns from that table including useful attributes..

I have gotten this far - however it will be really useful if I could find out (easily) whether there are any related tables (child table) and return those columns aswell. Would be a kinda of iterative thing. Would keep going to the last child (or parent I suppose)

Any help would be greatly appreciated here...

Cheers

Nev g

 

[nigelrivett]

The foreign keys are held in sysreferences.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.