SQL Server 2000/2005 show all tables in a Database

This Query gives you all the Tables in Database.


Select table_name FROM Information_Schema.Tables