public static string GetColumnDefinitionsQuery()

in src/SqlAsyncCollector.cs [500:518]

• 19 lines of code
• 2 McCabe index (conditional complexity)

            public static string GetColumnDefinitionsQuery(SqlObject table)
            {
                return $@"
                    select
	                    {ColumnName}, DATA_TYPE +
		                    case
			                    when CHARACTER_MAXIMUM_LENGTH = -1 then '(max)'
			                    when CHARACTER_MAXIMUM_LENGTH <> -1 then '(' + cast(CHARACTER_MAXIMUM_LENGTH as varchar(4)) + ')'
                                when DATETIME_PRECISION is not null and DATA_TYPE not in ('datetime', 'date', 'smalldatetime') then '(' + cast(DATETIME_PRECISION as varchar(1)) + ')'
			                    when DATA_TYPE in ('decimal', 'numeric') then '(' + cast(NUMERIC_PRECISION as varchar(9)) + ',' + + cast(NUMERIC_SCALE as varchar(9)) + ')'
			                    else ''
		                    end as {ColumnDefinition}
                    from
	                    INFORMATION_SCHEMA.COLUMNS c
                    where
	                    c.TABLE_NAME = {table.QuotedName}
                    and
                        c.TABLE_SCHEMA = {table.QuotedSchema}";
            }