What is the query to list all the tables in database in SQL Server 2000?

Thanks in advance!