Is there a way to count all the tables in a database and get their names?<BR><BR>Thanks<BR>Turnip
What database are you using?
That allows all sorts of "questions" about DB schemas, including what tables (and what fields within tables and and and).<BR><BR>Just search for OpenSchema on MSDN and you'll hit it.<BR><BR>
Thanks,<BR><BR>Confusing as that was, after a bit of searching I managed to get the functionality I needed out of it.<BR><BR>Turnip
...there are too **** many options with OpenSchema. Most of which don't do anything useful. I would have had to experiment a bit myself. Glad you got it.<BR><BR>