select
T1.NAME AS TALBENAME,T2.NAME COLNAME,T3.name AS COLTYPE,t2.length AS COLLENGTH,
convert(varchar,t4.value) AS COLMEMO
from sysobjects t1,syscolumns t2,systypes t3,sysproperties t4 where t1.id=t2.id and t1.xtype='U'
and t2.xtype=t3.xtype and t1.id=t4.id and t2.colid=t4.smallid and t1.name='tab'
T1.NAME AS TALBENAME,T2.NAME COLNAME,T3.name AS COLTYPE,t2.length AS COLLENGTH,
convert(varchar,t4.value) AS COLMEMO
from sysobjects t1,syscolumns t2,systypes t3,sysproperties t4 where t1.id=t2.id and t1.xtype='U'
and t2.xtype=t3.xtype and t1.id=t4.id and t2.colid=t4.smallid and t1.name='tab'
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货