Column name written twice to add default constraint
Why does the column name need to be written twice when adding the default constraint?
1 answers ( 0 marked as helpful)
Hi Beulah!
Thanks for reaching out.
The first time is for the old name and the second time is for the new name. Thus, if we repeat a column twice, it means that we want to keep the old name of the column.
Hope this helps.
Best,
Tsvetelin