页面历史

select so.name as tableName,sc.name as columnName,sp.value as remarks 
from sysobjects so left 
outer join syscolumns sc on so.id = sc.id left 
outer join sysproperties sp on sc.id = sp.id and sc.colid = sp.smallid 
where so.type = 'u' and so.name='$tableName$'
order by so.id, sc.colorder

SELECT tableName = D.NAME ,columnName=A.NAME, remarks=ISNULL(G.[VALUE], ' ') 
FROM SYSCOLUMNS A LEFT JOIN SYSTYPES B ON A.XUSERTYPE=B.XUSERTYPE 
INNER JOIN SYSOBJECTS D ON A.ID=D.ID AND D.XTYPE= 'U ' AND D.NAME <> 'DTPROPERTIES ' 
LEFT JOIN SYSCOMMENTS E  ON A.CDEFAULT=E.ID 
LEFT JOIN sys.extended_properties G ON A.ID=G.major_id AND A.COLID=G.minor_id 
LEFT JOIN sys.extended_properties F  ON D.ID=F.major_id AND F.minor_id=0 
where D.NAME='$tableName$' 
ORDER BY A.ID,A.COLORDER