获取SQL Server自定义表的字段名组合

获取SQL Server自定义表的字段名组合

SELECT o.name, stuff((select ','+ s.name from dbo.syscolumns s WHERE s.id=o.id 
ORDER BY s.colid FOR xml PATH('')), 1, 1, '') as FieldText
FROM dbo.sysobjects o WHERE o.xtype='U' 
GROUP BY o.name,o.id,o.xtype