SELECTsysobjects.name as table_name,syscolumns.name as column_name,systypes.name as datatype,syscolumns.length as lengthFROMsysobjectsJOINsyscolumnsONsysobjects.id=syscolumns.idJOINsystypesONsyscolumns.xtype=systypes.xtypeWHEREsysobjects.xtype=’U‘ORDERBYsysobjects.name,syscolumns.colid