SQL Server 2000/2005 show all tables in a Database

Freom this Query you can see all the Tables in Database


Select table_name FROM Information_Schema.Tables