Get All tables infromation from the database

SELECT * from sysobjects where xtype =’U’