Does anyone know of any ADO or SQL to list the table name contents of a database?

Regards Gary