ÓÃSQLÓï¾äµÃµ½SQLServer µÄ±íÖеÄÁеÄÃèÊöÖµ

 select   case   when   c.colid=1   then   object_name(c.id)   else   ''   end   as   ±íÃû    
  ,c.name   as   ×Ö¶ÎÃû  
  ,t.name   Êý¾ÝÀàÐÍ  
  ,c.prec   as   ³¤¶È  
  ,p.value   as   ÃèÊöÐÅÏ¢  
  ,m.text   as   ĬÈÏÖµ  
  from   syscolumns   c  
  inner   join   systypes   t   on   c.xusertype=t.xusertype  
  left   join   sysproperties   p   on   c.id=p.id   and   c.colid   =   p.smallid  
  left   join   syscomments   m   on   c.cdefault=m.id  
  where   objectproperty(c.id,'IsUserTable')=1