By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
DECLARE @sql nvarchar(max),
@create nvarchar(max) = N'CREATE TABLE dbo.DBs
(--';
SET @sql = N'SELECT database_id, name FROM sys.databases;';
SELECT @create += ',' + CHAR(13) + CHAR(10) + ' '
+ name + ' '
+ system_type_name
+ CASE is_nullable WHEN 0 THEN ' NOT' ELSE ' ' END
+ ' NULL'
FROM sys.dm_exec_describe_first_result_set(@sql, NULL, 0) AS f;
SELECT @create += CHAR(13) + CHAR(10) + N');';
PRINT @create;
-- EXEC sys.sp_executesql @create;
CREATE TABLE dbo.DBs
(--,
database_id int NOT NULL,
name nvarchar(128) NULL
);