without cursor

DECLARE @SQL NVARCHAR(max) = N''

SELECT @SQL = @SQL + '

SELECT ''['+ltrim(rtrim(sq.name))+'].['+ltrim(rtrim(obj.name))+']'' AS table_name,

...