クエリーテーブル名の列タイプと長さの指定

SELECT sysobjects.name AS   , syscolumns.name AS   ,   
systypes.name AS     , syscolumns.length AS       
FROM  
sysobjects INNER JOIN  
syscolumns ON sysobjects.id = syscolumns.id INNER JOIN  
systypes ON syscolumns.xtype = systypes.xtype  
WHERE (sysobjects.xtype = 'u' OR  
sysobjects.xtype = 'v') AND (systypes.name <> 'sysname')  
--and CONVERT(char,sysproperties.[value]) <> 'null' --      'null'     
AND (sysobjects.name = 'test') --      ，   or      
ORDER BY