Select * from sysobjects where xtype in ('u', 's') as u stand for usercreated table and s stand for systemgenerated table