How do I find out how many tables there are in a database using SQL or ADO????

Thanx,
Squirrelly1