GetGenericReportMetadata.sql

CREATE OR ALTER PROC [dbo].[GetGenericReportMetadata]
(
	@Schema VARCHAR(50)
	, @Table VARCHAR(50)
)

AS

SELECT ROW_NUMBER() OVER (ORDER BY c.column_id) [ID]
	, 'Column' + RIGHT('000' + CAST(ROW_NUMBER() OVER (ORDER BY c.column_id) AS VARCHAR(10)), 3) [ColumnID] 
	, c.name [ColumnName]
FROM sys.schemas s
INNER JOIN sys.objects o
	ON s.schema_id = o.schema_id
INNER JOIN sys.columns c
	ON c.object_id = o.object_id
WHERE o.type IN ('U')
	AND s.name = @Schema
	AND o.name = @Table
GO