在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') 
原文地址:https://www.cnblogs.com/quwujin/p/12040636.html