___ __ __         __
 | |_ /  |__||\ |/  \
 | |__\__|  || \|\__/

      - beauchamp.me -

SQL Server query to list all user tables in a database

September 25, 2008 updated October 16, 2008 SQL Server 2005

select name from sysobjects where type = ‘U’