Need help in sql.

Question

I am looking an answer for this question.

How to create a column in sql that have same values for its entire row.

I want to create column(Preid), and in this i just want to assign 'DZWA'(Some unqiue id related) but the thing is-
I just want to assign only for first time not every time. And it should be same every time(automatic).

Answer 1

I guess you should add "Default" value for your colum of table