Add column in table/dataset

How to add a column in a table? Or if possible with default value.

See if above serves your needs

1 Like

how can i column with string values?

As i’ve tried to add a column, it needs to add/input in calculated field.

Try something like this:

SELECT A, ‘abc’ AS new_field, B, C, D, E, F, G, H, I, J, K, L, M, N, O, P, Q, R, S, T, U, V, W

I highlighted your new field expression in bold
So your new_field will be string ‘abc’