在navicate中定义查找列名快捷方式
Select DISTINCT STUFF(( SELECT ',' + name FROM SysColumns WHERE id = a.id FOR XML PATH('') ), 1, 1, '') Name FROM SysColumns a Where id=Object_Id('TableName')
Select DISTINCT STUFF(( SELECT ',' + name FROM SysColumns WHERE id = a.id FOR XML PATH('') ), 1, 1, '') Name FROM SysColumns a Where id=Object_Id('TableName')