Sql query for table/column metadata

SELECT autoval,sys.syscolumns.length, sys.syscolumns.name, sys.sysobjects.name AS TableName ,sys.systypes.name,
 * FROM sys.sysobjects
LEFT OUTER JOIN sys.sysusers ON sys.sysobjects.uid = sys.sysusers.uid
LEFT OUTER JOIN sys.syscolumns ON sys.syscolumns.id = sys.sysobjects.id
LEFT OUTER JOIN sys.systypes ON sys.syscolumns.xusertype = sys.systypes.xtype
      WHERE (sys.sysobjects.type = 'U')