1、纵向列出所有字段
SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'tablename';
![在这里插入图片描述](https://img-blog.csdnimg.cn/direct/bb396aada54e41f7a147a70020afbf60.png)
2、横向列车所有字段,以‘,’分隔
SELECT STUFF((SELECT ', ' + column_name
FROM information_schema.columns
WHERE table_name = 'tablename'
FOR XML PATH('')), 1, 2, '') AS all_columns
![在这里插入图片描述](https://img-blog.csdnimg.cn/direct/45e72ad3fee345948fe460b1e91ef411.png)