select o.name as table_name,c.name as field_name,t.name as type,c.length as
length,c.isnullable as isnullable,convert(varchar(30),p.value) as desp from syscolumns c join systypes t on c.xtype = t.xusertype join sysobjects o on o.id=c.id leftjoin sysproperties p on p.smallid=c.colid and p.id=o.id where o.xtype='U') as mytable