{OWNER, TABLE, S, COLUMN, COMPUTE, NOTNULL, IDENTITY, DOMAIN, ExtIdentityIncrement, ExtIdentitySeed,  /* добавить */  @OBJTLABL}

select
   u.name,
   o.name,
   c.colid,
   c.name,
   z.text,
   case (c.status &  8 ) when  8  then 'NULL' else 'NOTNULL' end,
   case (c.status &  128 ) when  128  then 'identity' else '' end,
   case when (s.usertype <  100 ) then '' else s.name end,
   ident_incr(u.name + '.' + o.name),
   ident_seed(u.name + '.' + o.name),

    /* добавить */ 
   d.Value

from
   dbo.sysusers u
      join dbo.sysobjects o on (o.uid = u.uid)
      join dbo.syscolumns c on (c.id = o.id)
      join dbo.systypes s on ((c.usertype =  0  and s.xtype = c.xtype) or (c.usertype >  0  and s.usertype = c.usertype))
      left outer join dbo.systypes x on (x.type = s.type and s.usertype >= 100  and x.usertype = (select min(w.usertype) from dbo.systypes w where w.type=x.type))
      left outer join dbo.syscomments z on (z.id = o.id and z.number = c.colid)

       /* добавить */ 
      join ::fn_listextendedproperty('MS_Description',  'user', 'dbo', 'table', %.q:TABLE%, 'column', default) d on d.objname = c.name

where
   c.usertype >=  0 
   and c.name is not NULL
[  and u.name = %.q:SCHEMA%]
[  and o.name=%.q:TABLE%]
order by  1 ,  2 ,  3