Re: Finding the dbspace a db resides in

In article <5rj491$8b7@webserver>, otto@alldata.com (Doug Otto) wrote: > > Anyone got a quick and dirty way to find out what dbspace a particular > database resides in? I know the info is available from tbcheck -pe > but I've got over 700 databases in my instance and it's kind of a pain > doing it that way. > > Thanks in advance. > > BTW - I'm running 5.07 > > -- > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > Doug Otto otto@alldata.com > Alldata Corporation dotto@calweb.com > Technical Manager, Database Development (800) 829-8727 ext. 3137 Try this query against the sysmaster database: select b.dbsname, a.name from sysdbspaces a, systabnames b where a.dbsnum= partdbsnum(b.partnum) and b.tabname="systables" and b.dbsname="yourdbname" Just substitute for "yourdbname". Chuck Ludwigsen <cludwigs@hotmail.com> Database Engineer Its quick, its dirty, it works ;-) -------------------==== Posted via Deja News ====----------------------- http://www.dejanews.com/ Search, Read, Post to Usenet