Amit,
That's the idea, yes. Obviously, this info has to be collated from several different sources:
sysobjects, sysfultextcatalogs, sysindexes, sysfilegroups, OBJECTPROPERTY(), etc
I'm fully prepared to sit down and do this myself! No good programmer wants to re-invent the wheel though, hence my original question:
Do queries for retrieving this info exist in the public domain?
Of course, all help gratefully and respectfully received.
Ben