SELECT Table_Name
    FROM INFORMATION_SCHEMA.TABLES 
where Table_type = 'Base Table'


Second:

select Name from sysobjects where xtype = 'U'