There is a system table called MSysObjects, which is a list of all objects in the database. You can see this an all the other system tables by going to Tools->options->View Tab, and set the "System Objects" checkbox. To get a list of all tables [code]Select Name
FROM MSysObjects
WHERE type =1[code/]
will give you all table names (Including the System tables). You can do similar with other objects (I think for Querues, Type = 5).
Not sure about fileds, but they may turn up in this table. Have a look and see what you get.




Reply With Quote