Dynamic list of table names

1

Hi,
Is it possible to dynamically get a list of table names from a SQL database?

2

Found it!
Can do it with a query:

SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = ‘BASE TABLE’ AND TABLE_CATALOG=‘database_name’