在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') 

 

posted @ 2019-12-14 19:38  E山猫  阅读(512)  评论(0)    收藏  举报