select name
from sysobjects
where xtype = 'U'

##</code><code>##

select TABLE_NAME from INFORMATION_SCHEMA.TABLES