79167008

Date: 2024-11-07 15:03:34
Score: 1
Natty:
Report link

In case you may want a one liner.

SELECT TABLE_NAME
,STRING_AGG(CONVERT(NVARCHAR(max), COLUMN_NAME), ',') As THE_COLUMNS
FROM INFORMATION_SCHEMA.COLUMNS
GROUP BY TABLE_NAME
Reasons:
  • Low length (1):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: Mike Casas