Select
B.Name As TableName,
A.Name As ColName
From SysColumns A
Inner Join SysObjects B
On A.ID=B.ID
Where A.Xtype=35 And B.Xtype='U'
B.Name As TableName,
A.Name As ColName
From SysColumns A
Inner Join SysObjects B
On A.ID=B.ID
Where A.Xtype=35 And B.Xtype='U'
不好意思,你的方法也很好,谢谢!paoluo(一天到晚游泳的鱼)
希望不要介意我分3分给xeqtr1982:)