Following query will put '' in braces:
SELECT COLUMN_NAME + ' ' + DATA_TYPE + '(' + isnull(CONVERT(varchar(10),CHARACTER_MAXIMUM_LENGTH),'')+')' + 'How ;,'
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'PageAccessLog'
ORDER BY ORDINAL_POSITION
However if you want to avoid braces as well and handling special case for decimal:
SELECT COLUMN_NAME + ' ' + DATA_TYPE +
case when CHARACTER_MAXIMUM_LENGTH is null then
case when DATA_TYPE = 'Decimal' then '(' + CONVERT(varchar(10),Numeric_Precision) + ', ' + CONVERT(varchar(10),NUMERIC_SCALE) +')'
else '' end
else '(' + isnull(CONVERT(varchar(10),CHARACTER_MAXIMUM_LENGTH),'')+')' end + ' How ;,'
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'PageAccessLog'
ORDER BY ORDINAL_POSITION